Chapter 5, Problem 5.18RQ

Explanation of Solution

One-to-many relationship (1:N):

• One-to-many relationship is one of the types of binary relationship that refer to the relationship between two entities which means one parent field or record can be associated with one or more child field or record.
• In a one-to-many relationship (1:N), a parent is a row on the one side of 1:N, while a child is a row on the many side of 1:N which means one parent may contains many child.

Reason for placing the key in the child table which belongs to parent table:

• The parent relation is the “one” and the child relation is “many” in 1:N relationship. An attributes in a parent relation contain only one value.
• If the key belonging to the child was placed in the parent table, then the design should not be used to represent many side of the 1:N relationship...