The big idea: An ERD shows the things a database stores and how they relate.
Each box is an entity — one kind of thing, which will become a table. Each line is a relationship between two of them.
Why draw it at all: A mistake in an ERD costs a pencil line. The same mistake found after the database is full of data costs a rebuild.
It is also the one document a non-technical person can check and correct.
Free preview
This is the free notes preview
You're reading the free notes. Aimnova Pro unlocks the full study experience — and you can try it with your first topic free to keep:
- FlashcardsLock in vocabulary and key terms with spaced repetition.
- Practice questionsAnswer exam-style questions and get instant AI marking.
- Mock exams & past-paper vaultSit full mocks and see exactly how examiners award marks.
- Personalised study planA daily plan built around your exam date and weak areas.
Each relationship type, read both ways, with how it is built in tables. Step through all four.
Interactive diagram
Explore the labelled diagram, charts and maps for this topic in full study mode.
Cardinality — how many
- One to one — each side has at most one of the other
- One to many — one on one side, several on the other
- Many to many — several on both sides
- Drawn with a bar for one and a crow's foot for many
Modality — is it compulsory
- Mandatory — there must be at least one
- Optional — there may be none
- Drawn with a second bar for mandatory, a circle for optional
- A student may have no club yet: optional on the club side
Read every relationship twice: Once each way. "A teacher teaches many classes" and "a class is taught by one teacher".
Both sentences together give you the cardinality. Get into the habit and you will never draw the crow's foot on the wrong end.
Practice with real exam questions
Answer exam-style questions and get AI feedback that shows you exactly what examiners want to see in a full-marks response.
1 — Find the entities
2 — Find the relationships
3 — Decide cardinality both ways
4 — Resolve any many-to-many
The linking entity usually has a name: It is rarely just glue. Member-to-Book becomes Loan, which also holds the date borrowed and the date due.
If you cannot think of a name for it, you have probably missed data that belongs on it.
How this is tested — you must draw the right cardinality on the right end, and resolve any many-to-many. It comes up two ways:
Paper 1 Section A
- Construct an ERD from a scenario, 4-6 marks
- State the cardinality of a described relationship
- Explain what a linking table is for
Paper 1 Section B — case study
- Draw the ERD for the case study's data
- Explain why a particular relationship takes the form it does
The classic trap: Leaving a many-to-many undrawn. A relational database cannot store it — there is nowhere to put a foreign key holding several values — so the linking entity is part of the answer, not an optional extra.
A hospital records which doctors treat which patients, and each patient is assigned one ward. Construct an ERD for this, explaining your cardinalities.
Model answer plan
See the mark-by-mark plan — for / against / judgement, with marking guidance — in study mode.