6. Which of the following situation requires the use of ID-dependent entities?
A. Association relationships only
B. Multivalued attributes only
C. Archetype/instance relationships only
D. All of the above use ID dependent entities
7. A foreign key is:
A. a column containing the primary key of another table.
B. used to define data types.
C. used to define null status.
D. all of the above are above correct.
8. Which of the following columns is(are) are required in a table?
A. A foreign key
B. An alternate key
C. A primary key
D. A surrogate key.
9. In a 1:1 relationship, the foreign key is placed in:
A. either table without specifying parent and child tables.
B. the parent table.
C. the child table.
D. either the parent table or the child table.
10. 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?
A. Null status
B. Data type
C. Default value
D. Data constraints