Database normalisation and normal forms: Theory

Specification Points
Specification Reference Specification Point
3.1.5 c

Idenify the characteristics of data in unnormalised (0NF), first normal form (1NF), second normal form (2NF) and third normal form (3NF)

3.1.5 d

Describe the advantages and disadvantages of normalisation

Resources

Mini Website

This mini website covers the specification points above.

Students should read through the information and make their own notes.

There are some suggestions for tasks in the 'Lesson Ideas' section which could be used to accompany the website.

storage theory miniweb