Relational Model Flashcards
(10 cards)
What is the main focus of system design?
The “how” aspect—implementation details of the system.
What is the output of database design?
A logical data model.
What is the de facto standard data model in the industry?
Relational model.
What is a tuple in relational model terms?
A row in a table.
What does a primary key do?
Uniquely identifies each tuple (row) in a table.
What ensures referential integrity?
Every FK must reference an existing PK in another table.
In one-to-many relationships, where does the FK go?
In the “many” side table.
What does cardinality mean in a relational model?
Number of tuples (rows) in a table.
Can attributes in a relational table have multiple values?
No. Only single values per attribute.
Who proposed the relational model?
E.F. Codd in 1970.
