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.