Database design
A3.2What the syllabus asks of you
- A3.2.1 Describe database schemas.
- A3.2.2 Construct ERDs.
- A3.2.3 Outline the different data types used in relational databases.
- A3.2.4 Construct tables for relational databases.
- A3.2.5 Explain the difference between normal forms.
- A3.2.6 Construct a database normalized to 3NF for a range of real-world scenarios.
- A3.2.7 Evaluate the need for denormalizing databases.
I'm studying
Drill this topic
Every question on Database design that your level can use, untimed — answer on paper, then mark yourself against the mark scheme.
Make a worksheet
Choose the years and how many questions, then print it with the answers on separate pages.
363838 questions
These are structured questions, answered in working rather than by picking an option, so they are not listed here one by one. The drill above puts each in front of you with its mark scheme to check against.

