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

Question

Quizplus · Accepted Answer

In an E-R data model, when a child entity is ID-dependent on its parent entity, the key of the parent entity is included as part of the child entity's primary key. This is because the existence of the child entity is directly dependent on the parent entity, and its identity is partially derived from the parent's key.

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