Week 2: Relational Databases Flashcards
What is the hierarchical model? What is the problem with it?
Problem: repetition of data stored as children of other data.
What is the network data model? What is its problem?
Problem: representing many to many relationships
What is a key? what are its contraints?
What are some possible keys for the following table?
What are the following:
super key
Candidate key
Primary key
Foreign key
Example of key types
What are some key constraints?
What are the following for a relational DB?
Domain
Relation Schema R
Relation
Attribute
Tuple
Degree
Cardinality
What are the fomain, relation schma, Relation, R, attributes, degree, and cardinality of the following:
What is the cartesian product of two sets?
What are the following in a relational database table?
Relation
Attribute
Tuple
Cartesian product
What are the properties of relations?
What rule is there for creating a relational database from an ER diagram?
How is the following represented as a relational model?
How do you represent a 1 to Many relationship in an relational DB model?
How do you represent weak entities in relational DB model?
How do you represent a 1 to 1 relationship in relational DB model?
How do you represent a many to many binary relationship in a relationol DB model?
How do you represent a multivalued attribute A in a relational DB model?
How do you represent an n-ary relationship n>2 in a relational DB model?
