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,but method A is preferable
E)either A or B will work,but method B is preferable

Question

Quizplus · Accepted Answer

The Answer of 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,but method A is preferable
E)either A or B will work,but method B is preferable

When Transforming an ID-Dependent E-R Data Model Relationship into a Relational