Recall & Review
beginner
What is a relationship in a database context?
A relationship connects two or more pieces of data to show how they relate to each other, like how a person owns a car.
Click to reveal answer
beginner
Why do relationships help model real-world data?
Because real-world things are connected, relationships let us represent these connections clearly in data, making it easier to understand and use.Click to reveal answer
beginner
Give an example of a real-world relationship modeled in data.
A student enrolls in courses. The relationship between students and courses shows which students take which classes.
Click to reveal answer
intermediate
How do relationships improve data organization?
They reduce repetition by linking related data instead of copying it, which keeps data clean and easier to update.
Click to reveal answer
intermediate
What types of relationships commonly exist in databases?
Common types are one-to-one, one-to-many, and many-to-many, describing how many items in one group relate to items in another.
Click to reveal answer
What does a relationship in a database represent?
✗ Incorrect
A relationship shows how data items are connected, like linking a customer to their orders.
Which relationship type means one item relates to many items?
✗ Incorrect
One-to-many means one item connects to many others, like one teacher with many students.
Why do relationships reduce data repetition?
✗ Incorrect
Relationships link data items so you don’t have to store the same data repeatedly.
Which example shows a real-world relationship?
✗ Incorrect
A book having an author shows a real-world connection modeled as a relationship.
What is the main benefit of modeling relationships in data?
✗ Incorrect
Modeling relationships helps us see how data items connect, reflecting real-world links.
Explain why relationships are important for modeling real-world data.
Think about how things in life are connected and how data can show that.
You got /4 concepts.
Describe the common types of relationships in databases and give a simple example for each.
Focus on how many items in one group relate to items in another.
You got /4 concepts.