Skip to content
Learnearn.uk » IB Computer Science » Database Normalisation – 1nf, 2nd & 3nf

Database Normalisation – 1nf, 2nd & 3nf

Normalisation

Database Normalisation

Normalisation is the process of removing redundancy within a database.

Doing so:

  • Makes accessing and storing data easier and more efficient
  • Makes maintaining the database contents quicker and easier
  • Reduces the chances of data errors or duplication.

In order to a achieve this a set of rules were established to achieve efficiency – 1st, 2nd and 3rd normal form. Each rule builds on the last rule, but think of it as a mental process that you go through to improve your database.

Tutorial Video

1NF

2NF

3NF

Resources