Database Normalisation (1NF, 2NF, 3NF) — Complete A-Level Computer Science Teaching Pack (AQA | OCR)

Complete A-Level Computer Science teaching pack on Database Normalisation (1NF, 2NF, 3NF). Includes lesson, worksheet, homework & full answers. AQA & OCR.
Database normalisation at A-Level requires a deep understanding of data structures, functional dependencies, and relational integrity. This complete teaching pack takes the confusion out of the normalisation process, providing a rigorous, step-by-step approach to converting unnormalised data into First, Second, and Third Normal Form.
Created by an experienced Computer Science teacher and tutor with over 20 years in education, this pack is fully mapped to the AQA (7517) and OCR (H446) A-Level specifications.
What is included in this pack?
A 13-slide lesson presentation walks students through the fundamental problems of flat-file databases — including update, insertion, and deletion anomalies — before explaining the rules for 1NF, 2NF, and 3NF using clear, complex worked examples involving composite keys, partial dependencies, and transitive dependencies. A student worksheet reinforces learning with theory questions on database anomalies, key terminology matching, and a practical step-by-step normalisation challenge based on a veterinary clinic scenario. A homework task features two challenging exam-style questions requiring students to identify dependency violations and normalise complex multi-table structures to 3NF, including a library loans database and a company training records database. A complete teacher answer scheme provides full answers and step-by-step working-out for every question on both the worksheet and the homework.
Topics covered include:
Flat-file vs relational databases, update, insertion and deletion anomalies, primary, foreign and composite keys, First Normal Form (1NF), Second Normal Form (2NF) and partial dependencies, and Third Normal Form (3NF) and transitive dependencies.
Who is this for?
Ideal for KS5 Computer Science teachers delivering the A-Level specification across AQA or OCR. Particularly well-suited to those who need a clear, structured approach to teaching this abstract and challenging topic.
Save hours of planning time and give your students the best possible preparation for their A-Level database exam questions.