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.
What it covers
At GCSE (F7.2) you met tables, records, fields, primary keys and foreign keys. At A level the vocabulary is more exact, there are more kinds of key, and you need to say how a database finds a record quickly. This lesson turns the entity descriptions of the last lesson into a relational database.
- Flat files and relational databases
- The vocabulary
- Keys
- Indexes
- How records are found in a file
Or do it in the simulator, with tasks that mark themselves
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.