Relations, tuples, and attributes in DBMS Theory - Mini Project: Build & Apply

Understanding Relations, Tuples, and Attributes in a Database

📖 Scenario: You are learning how data is organized in a simple database system. Imagine a table that stores information about books in a library. Each row in the table represents one book, and each column represents a detail about the book, like its title or author.

🎯 Goal: Build a clear example of a relation (table) with tuples (rows) and attributes (columns) to understand how data is structured in databases.

📋 What You'll Learn

Create a relation named Books with three attributes: BookID, Title, and Author.

Add three tuples (rows) with exact values for each attribute.

Define a variable to count the number of tuples in the relation.

Use a loop to list all book titles from the relation.

💡 Why This Matters

🌍 Real World

Understanding relations, tuples, and attributes helps in designing and querying databases used in libraries, stores, websites, and many other applications.

💼 Career

Database administrators, data analysts, and software developers use these concepts daily to organize, retrieve, and manage data efficiently.

1

Create the relation with tuples

Create a relation called Books as a list of tuples. Each tuple should have three values: BookID, Title, and Author. Add these exact tuples: (1, '1984', 'George Orwell'), (2, 'To Kill a Mockingbird', 'Harper Lee'), and (3, 'The Great Gatsby', 'F. Scott Fitzgerald').

DBMS Theory

# Create the relation Books with the given tuples
# Your code here

Need a hint?

Use a list of tuples to represent the relation. Each tuple holds the attributes for one book.

2

Count the number of tuples

Create a variable called tuple_count and set it to the number of tuples in the Books relation using the len() function.

DBMS Theory

Books = [
    (1, '1984', 'George Orwell'),
    (2, 'To Kill a Mockingbird', 'Harper Lee'),
    (3, 'The Great Gatsby', 'F. Scott Fitzgerald')
]
# Create tuple_count to hold the number of tuples
# Your code here

Need a hint?

Use the len() function to find how many tuples are in the list.

3

List all book titles

Use a for loop with the variable tuple to go through each tuple in Books. Inside the loop, create a list called titles before the loop and add each book's title (the second element in the tuple) to this list.

DBMS Theory

Books = [
    (1, '1984', 'George Orwell'),
    (2, 'To Kill a Mockingbird', 'Harper Lee'),
    (3, 'The Great Gatsby', 'F. Scott Fitzgerald')
]
tuple_count = len(Books)

titles = []
for tuple in Books:
    # Add the title (second element) to titles
    # Your code here

Need a hint?

Remember that tuple elements start at index 0, so the title is at index 1.

4

Define attributes list

Create a list called attributes that contains the attribute names of the relation: 'BookID', 'Title', and 'Author'.

DBMS Theory

Books = [
    (1, '1984', 'George Orwell'),
    (2, 'To Kill a Mockingbird', 'Harper Lee'),
    (3, 'The Great Gatsby', 'F. Scott Fitzgerald')
]
tuple_count = len(Books)

titles = []
for tuple in Books:
    titles.append(tuple[1])

# Create the attributes list
# Your code here

Need a hint?

Attributes are the column names of the relation. Use a list to store them.