Year 11 Computer Science ATAR: Normalisation to 3NF

Students learn why redundant data causes anomalies and how to remove it by taking tables through first, second and third normal form using functional dependencies.

One content description from the full WA Computer Science ATAR Year 11 — Data Management 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 Insertion, update and deletion anomalies 3 Functional dependency and determinants 4 First normal form (1NF) 5 Second normal form (2NF) 6 Third normal form (3NF) 7 Normalising a table step by step to 3NF

Add to class →

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 →

Have a class code?