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, and neither way is preferable
D) either A or B will work, and method A is preferable
E) either A or B will work, but method B is preferable
Diff: 3 Page Ref: 201, 206