Multiple Choice
When transforming an ID-dependent E-R data model relationship into a relational database design and the parent entity has a surrogate primary key and the child entity has a data identifier,then the primary key of the child table should be ________.
A) the parent's surrogate key + the child's data key
B) the parent's surrogate key + a surrogate key in the child
C) either A or B will work,but method A is preferable
D) either A or B will work,but method B is preferable
Correct Answer:

Verified
Correct Answer:
Verified
Q1: Whether or not an attribute is required
Q2: To represent a one-to-many relationship in a
Q3: To represent an IS-A relationship in a
Q4: To represent a one-to-many relationship in a
Q6: A surrogate key is appropriate when the
Q7: When transforming an extended E-R model into
Q8: The values of a surrogate key have
Q9: The ideal primary key is short,numeric,and fixed.
Q10: When representing a 1:1 relationship in a
Q11: Which of the following is not true