1. Which of the following situation requires the use of ID-dependent entities?
2. A foreign key is:
3. Which of the following columns is(are) are required in a table?
4. In a 1:1 relationship, the foreign key is placed in:
5. Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
6. The identifier of an entity will become the ________ of the new table.
7. Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
8. A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
9. Which is not true about surrogate keys?
10. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
11. Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
12. Each entity is represented as a(n):
13. For every relationship, how many possible sets of minimum cardinalities are there?
14. If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
15. Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
16. A foreign key is used to implement relationships between tables.
17. The terms alternate key and candidate key mean the same thing.
18. In 1:N relationships, which entity becomes the parent entity is arbitrary.
19. When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.
20. In a 1:1 relationship, the primary key placement is arbitrary.
21. When the parent entity is required, a new child row can always be inserted.
22. All primary keys are required.
23. Intersection tables are ID-dependent on both their parent tables.
24. For every relationship, there are six possible sets of minimum cardinalities.
25. An intersection table is required to represent M:N relationships.