Cardinality

Also known as · ERD Cardinality

How many rows on one side of a Relationship relate to rows on the other: 1:1, 1:N or M:N, for example one customer has many rentals.

When to use

PP 03 Q3 asks which cardinality a join result shows, and PP 04 Q6 asks about composite versus surrogate keys on a many-to-many table. An M:N link needs a Junction Table holding two foreign keys.

See PP 04.

Appears in