Answer to Question #151758 in Databases | SQL | Oracle | MS Access for Xolile

Question

What is Normalization

Answer 1

Normalization is a database design technique that reduces data redundancy and removes unwanted characteristics such as insert, update, and delete anomalies. Normalization rules divide large tables into smaller ones and link them using relationships. The goal of normalization in SQL is to eliminate redundant (duplicate) data and provide logical data storage.

The inventor of the relational model, Edgar Codd, proposed the theory of data normalization with the introduction of the first normal form and went on to expand the theory with the second and third normal forms. He later joined Raymond F. Boyes to develop the Boyce-Codd normal form theory.

Here is a list of normal forms:

1NF (first normal form)

2NF (second normal form)

3NF (Third Normal Form)

BCNF (Boyce-Codd Normal Form)

4NF (fourth normal form)

5NF (fifth normal form)

6NF (sixth normal form)

The Theory of Data Normalization in SQL server is still being developed further. For example, there are discussions even on 6^th Normal Form. However, in most practical applications, normalization achieves its best in 3^rd Normal Form.