One-to-Many Relationship

One row on the parent side relates to many rows on the child side. It is implemented by putting a Foreign Key in the child table that points at the parent's Primary Key.

When to use

In PP 02 the foreign key sits on the "many" side of each one-to-many relationship (the grade table in the official answer), and PP 03 rules out one-to-many versus many-to-many by counting tables. One customer with many rentals is the course's standard example.

See PP 02.

Appears in