Database Normalisation (1NF, 2NF, 3NF) — Complete GCSE Computer Science Teaching Pack (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 takes the confusion out of 1NF, 2NF, and 3NF, providing a clear, step-by-step approach to teaching relational database design.

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.

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).

Save hours of planning time and give your students the best possible preparation for their database exam questions.