QCE Digital Solutions Unit 2: Normalising a database to 3NF
Students learn to spot redundancy and anomalies, evaluate tables against 1NF, 2NF and 3NF, and modify a database to third normal form.
One content description from the full QCE Digital Solutions Unit 2 — Prototype Data Solutions journey. All 7 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (7)
1
The repeated-data problem in one big table
2
Insert, update and delete anomalies
3
First normal form (1NF) (Prototype Data Solutions)
4
Second normal form (2NF) (Prototype Data Solutions)
5
Third normal form (3NF) (Prototype Data Solutions)
6
Evaluating a database against the normal forms
7
Modifying a database to 3NF
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 →