- Normalisation
- Tutorial Video
- 1NF
- 2NF
- 3NF
- Resources
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