Question 1 :
A foreign key is used to implement relationships between tables.
Question 2 :
The terms alternate key and candidate key mean the same thing.
Question 3 :
In 1:N relationships, which entity becomes the parent entity is arbitrary.
Question 4 :
When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.
Question 5 :
In a 1:1 relationship, the primary key placement is arbitrary.
Question 6 :
When the parent entity is required, a new child row can always be inserted.
Question 7 :
All primary keys are required.
Question 8 :
Intersection tables are ID-dependent on both their parent tables.
Question 9 :
For every relationship, there are six possible sets of minimum cardinalities.
Question 10 :
An intersection table is required to represent M:N relationships.
Question 11 :
The DBMS allows surrogate keys to be changed.
Question 12 :
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
Question 13 :
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
Question 14 :
Surrogate keys have much meaning for users.
Question 15 :
When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.
Question 16 :
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
Question 17 :
When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
Question 18 :
When the parent entity is required, a new parent row can always be inserted.
Question 19 :
For every relationship, there are six possible referential integrity actions.
Question 20 :
An ideal primary key is short, numeric and seldom changing.