052. OCR A Level (H446) SLR10 – 1.3 Normalisation to 3NF

About this video

OCR Specification Reference
A Level 1.3.2c

In this video we take a detailed look at the process of normalising a database from unnormalized through to third normal form by stepping through a worked example.

Key questions:

- What is the purpose of normalisation?
- How are 1NF, 2NF and 3NF defined?
- What are the rules of first, second, and third normal form?

00:00 Normalisation to 3NF
00:07 Intro
00:12 Database basics recap- Removing repeating/redundant data
01:20 Relationships
01:40 Primary Keys
02:10 Database normalisation
03:13 Normalisation- 0NF (flat file before any normalisation)
03:56 Normalisation- 1NF
09:23 Normalisation- 2NF
13:22 A trick for spotting when to split a table
15:16 Normalisation- 2NF continued
18:55 Normalisation- 3NF
23:36 Summary
24:24 Key questions
24:44 Going beyond the specification
25:00 Database normalisation
25:25 Higher normal forms
26:58 This is all too much!
27:59 Outro

Last updated: 11.05.26

Other videos on this course