Question

Question 4

To represent a one-to-many relationship in a relational database design, _____.

Group of answer choices

the key of the child is placed as a foreign key into the parent

the key of the parent is placed as a foreign key into the child

an intersection table must be created

the key of the table on the "many" side is placed in the table on the "one" side

the keys of both tables are joined into a composite key

Question 5

(TCO C) 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 _____.

Group of answer choices

when the child entity is ID dependent

when the child entity is non-ID dependent

when the child entity has a 1:1 relationship with the parent entity

when the child entity has a 1:N relationship with the parent entity

when the child entity has a recursive relationship with the parent entity

Answer 1

Q4. Parent entity is the entity on one side of relationship. Child entity is on the many side of relationship.

Here the correct option is (2).

the key of parent is present as foreign key into the the child.

The child entity has relation with only one instance of parent entity while parent entity can have more than one child entity. If the key of child is present as foreign key in parent entity then it will become a multi valued attribute which is not acceptable in 1NF.

Q5. The correct option is (1), when child entity is ID dependent.

This happen when child entity is a weak entity and does not have a primary key of its own and this have to be dependent on the parent entity.

If you have any questions comment down.. Also please upvote thanks