Recall & Review
beginner
What is a relation in the relational model?
A relation is like a table with rows and columns where data is stored. Each row is a record, and each column is an attribute.
Click to reveal answer
beginner
What does a tuple represent in the relational model?
A tuple is a single row in a relation, representing one record or data item.
Click to reveal answer
beginner
Explain the concept of attributes in the relational model.
Attributes are the columns in a relation. They define the type of data stored, like name, age, or price.
Click to reveal answer
intermediate
What is a primary key in the relational model?
A primary key is a unique attribute or set of attributes that identify each tuple (row) in a relation (table).
Click to reveal answer
intermediate
How does the relational model ensure data integrity?
It uses rules like primary keys to avoid duplicates and foreign keys to maintain valid links between tables.
Click to reveal answer
In the relational model, what does a relation correspond to?
✗ Incorrect
A relation is a table that organizes data into rows and columns.
What is a tuple in the relational model?
✗ Incorrect
A tuple is a single row representing one record in a table.
Which of the following best describes an attribute?
✗ Incorrect
Attributes are columns that define the data types stored in a table.
What is the purpose of a primary key?
✗ Incorrect
Primary keys uniquely identify each row in a table to avoid duplicates.
How does the relational model maintain data integrity?
✗ Incorrect
Primary and foreign keys enforce rules that keep data consistent and linked properly.
Describe the main components of the relational model and how they relate to a real-life spreadsheet.
Think about how a spreadsheet organizes data in rows and columns.
You got /4 concepts.
Explain why primary keys are important in the relational model and give an example.
Consider how you identify a person uniquely in a list.
You got /3 concepts.