AQA 7517 4.10.3: Database design and normalisation techniques
The free BugBot lessons that teach this point, a robot to try it on, and the past-paper questions that test it.
Lessons that teach it
- A11.3 Normalisation to third normal form Databases and big data
Functional dependencies, update anomalies, and taking a flat score sheet through first, second and third normal form. - A11.10 Project: the run database Databases and big data
Design, normalise, build and fill a database of robot runs, log live runs in transactions, report with one joined query and export the…
Try it on a robot
The task from A11.3 Normalisation to third normal form, running here. Change the program and press Run.
The specification is AQA's own document; this page says which of our lessons teach point 4.10.3 and is not endorsed by the board.