When transforming an E-R data model into a relational database design,the key of the parent entity should be placed as part of the primary key into the child entity ________.
A)when the child entity is ID-dependent
B)when the child entity is non-ID-dependent
C)when the child entity has a 1:1 relationship with the parent entity
D)when the child entity has a 1:N relationship with the parent entity
E)when the child entity has a recursive relationship with the parent entity

Question

Quizplus · Accepted Answer

When the child entity is ID-dependent, it means that its existence is dependent on the parent entity, and thus the key of the parent entity should be included as part of the primary key in the child entity to maintain this dependency.

When Transforming an E-R Data Model into a Relational Database