AQA 7517 4.10.1: Conceptual data models and entity relationship modelling
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 split one big table of robot runs into two linked tables, and met primary and foreign keys. The tables were given to you. At A level you design them yourself: start from what the users of a system need, model the data on paper, and only then build the database. This module follows the robotics club's data all the way: from a model, to a normalised database queried in SQL, to a database shared by many users at once, and finally to data too big for one machine.
- Conceptual data models
- Entity descriptions
- The degree of a relationship
- Resolving a many-to-many relationship
- Checking a degree against data
Or do it in the simulator, with tasks that mark themselves
Lessons that teach it
- A11.1 Data models and entity relationships Databases and big data
Model the data before building anything: entities, attributes, entity descriptions and the degree of each relationship, drawn as an entity… - 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.1 Data models and entity relationships, 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.1 and is not endorsed by the board.