Database Normalisation (1NF, 2NF, 3NF) — Complete A-Level Computer Science Teaching Pack (AQA | OCR)
Here is a ready-to-paste description for your Payhip listing:
---
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?**
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 that involve 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), partial dependencies, Third Normal Form (3NF), and transitive dependencies.
Ideal for KS5 Computer Science teachers and 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.