Normalisation Tutorial

1.1 Summary: 1NF
1.2 Exercise: Student details
1.3 Summary: 2NF
1.4 Exercise: Student details (continued)
1.5 Summary: 3NF
1.6 Exercise: Student details (continued)
1.7 Exercise: Student details (continued)
1.8 Exercise: Student details (completed)

2.1 Exercise: Determine the normal form
2.2 Exercise: Determine the normal form
2.3 Exercise: Determine the normal form
2.4 Exercise: Determine the normal form
2.5 Exercise: Determine the normal form (completed)

3.1 Another example: Patient Database
3.2 Solution for the Patient Database: 1NF
3.3 Solution for the Patient Database: 2NF
3.4 Solution for the Patient Database: 3NF

4.1 Reduce to BCNF: Supplier Database
4.2 1NF
4.3 Further normalisation
4.4 2NF
4.5 3NF
4.6 Summary

5.1 Exercise: GP Database
5.2 Exercise: Tour operator
5.3 Exercise: Software consulting firm

A complete listing of the normalisation exercises can be found here