AQA 7517 4.10.2: Relational databases
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.2 Relational databases and keys Databases and big data
Flat files against relational databases, and every kind of key: primary, composite, foreign and secondary, with indexes and how records… - A11.5 SQL: changing data and referential integrity Databases and big data
INSERT, UPDATE and DELETE at A level, and how a database refuses orphan records. The robot logs its own moves.
Try it on a robot
The task from A11.2 Relational databases and keys, 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.2 and is not endorsed by the board.