Entity-relationship modelling
A method designing databases by identifying entities (things), attributes (properties), and relationships (connections). ER diagrams visualize database structure before implementation.
Real World
The NHS Patient Database uses ER modelling to link Patient, Appointment, and Doctor entities — ensuring every booking connects a specific patient to a specific doctor with no orphaned records.
Exam Focus
Always label cardinality on every relationship line; examiners deduct marks for missing crow's foot notation.
How well did you know this?