Access Database Normalisation levels 1, 2, 3; getting normal about it!
The process of Database Normalisation was developed by E.F.Codd who is widely considered the father of relational database theory.
There are several rules which provide theoretical structures and disciplines which are not always practical to follow but help provide the main goals which are:
- Eliminate redundant information
- Increase data integrity
- Make systems more efficient
Modern databases should be in BCNF Boyce-Codd Normal Form which is deemed to be at third normal form of which there are considered to be five in all. This article focuses on what I believe is considered a good balance to applying some of these rules and covers up to the third norm of database normalisation.