One-to-One Relationship

A relationship where each row on either side has at most one partner on the other side.

When to use

Appears when classifying a relationship from an ERD or a scenario, as in PS 01 (hospital patient system). PP 03 rules it out when each output record stands for a group of several records.

See PS 01.

Appears in