example3nfWelcome to this tutorial on normalisation. These lessons are intended to get all students to fully understand the AS/A2 ICT and Computing topic of database normalisation, an often misunderstood topic that students frequently find difficult and confusing.

We start by looking at flat files their associated problems. We then move onto relational database design, using E-R diagrams to help us. With these tools under our belt, we then move on to normalisation to 3NF. Students will be shown examples that have been worked through one step at a time, with a clear commentary at every stage. They will be working through lots of closely guided database problems until they can confidently tackle any relational database problem themselves independently. All the answers and explanations to every question are given in the last section.

Please use the menu on the right hand side to navigate your way through the different sections.