Database Normalisation (1NF, 2NF, 3NF) — Complete GCSE Computer Science Teaching Pack (AQA | OCR | E

Complete GCSE Computer Science teaching pack on Database Normalisation (1NF, 2NF, 3NF). Includes lesson, worksheet, homework & full answers. AQA, OCR & Eduqas.
Database normalisation is often considered one of the most abstract and difficult topics on the GCSE Computer Science specification. This complete teaching pack provides a clear, step-by-step approach to teaching relational database design, taking students from the problems of flat-file databases all the way through to 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, OCR (J277), and Eduqas (2020) GCSE specifications.
What is included in this pack?
A 13-slide lesson presentation walks students through the problems of flat-file databases — including data redundancy and update, insertion, and deletion anomalies — before explaining the rules for 1NF, 2NF, and 3NF using clear worked examples. A student worksheet reinforces learning with a keyword matching activity, short-answer theory questions, and a practical normalisation challenge based on a Vet Clinic database. A homework task features exam-style questions including a scenario requiring students to design a 3NF database for a school sports club. A complete teacher answer scheme provides full answers and working-out for every question on both the worksheet and the homework.
Topics covered include:
Flat-file vs relational databases, data redundancy and anomalies, primary keys and composite keys, First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF).
Who is this for?
Ideal for KS4 Computer Science teachers delivering the GCSE specification across AQA, OCR, or Eduqas exam boards. Particularly well-suited to NQTs or non-specialist teachers who need a clear, structured approach to delivering this challenging topic.
Save hours of planning time and give your students the best possible preparation for their database exam questions.