Year 11 QCE Digital Solutions Unit 2: Primary keys, foreign keys and relationships
Students use primary and foreign keys to link tables in relational databases and show the links in entity relationship diagrams.
One content description from the full QCE Digital Solutions Unit 2 — Data-Driven Problems and Solution Requirements journey. All 10 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (10)
1
Primary key
2
Choosing a suitable primary key from a table
3
What is a relational database?
4
Foreign key and table relationships
5
One-to-many relationships between tables
6
One-to-one and many-to-many relationships
7
Referential integrity
8
Entity relationship diagram: entities and relationship lines
9
Crow's foot notation for one and many
10
Drawing an ERD from a scenario
For Teachers
Add this journey to your class and track every student in real time.
Create a free teacher account →No credit card. No setup fee. Make a class and invite students in under three minutes.
For Students
Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.
Start Learning Free →