Recall & Review
beginner
What is a relational database?
A relational database stores data in tables made of rows and columns. Each table represents an entity, and relationships between tables are made using keys.
Click to reveal answer
beginner
What is a primary key in a relational database?
A primary key is a column or set of columns that uniquely identifies each row in a table. It ensures no two rows have the same key value.
Click to reveal answer
intermediate
Explain the concept of foreign key.
A foreign key is a column in one table that refers to the primary key in another table. It creates a link between the two tables to maintain data consistency.
Click to reveal answer
intermediate
What is normalization in relational databases?
Normalization is the process of organizing data to reduce duplication and improve data integrity by dividing tables and defining relationships.
Click to reveal answer
beginner
What does SQL stand for and what is its role?
SQL stands for Structured Query Language. It is used to communicate with and manage data in relational databases by writing queries.
Click to reveal answer
Which of the following uniquely identifies a row in a table?
✗ Incorrect
The primary key uniquely identifies each row in a table.
What does a foreign key do?
✗ Incorrect
A foreign key links one table to another by referring to the primary key.
Normalization helps to:
✗ Incorrect
Normalization organizes data to reduce duplication and improve integrity.
Which language is used to query relational databases?
✗ Incorrect
SQL is the language used to query and manage relational databases.
In a table, columns represent:
✗ Incorrect
Columns represent attributes or fields describing data in each row.
Describe the role of primary and foreign keys in relational databases.
Think about how tables connect and keep data unique.
You got /3 concepts.
Explain why normalization is important in database design.
Consider how data is stored efficiently and cleanly.
You got /3 concepts.