Normailization in SQL Server

Normalization is a process of minimizing data redundancy with a series of steps called as normal forms.

The total normalization process includes the following normal forms.

• First Normal Form (1NF)
• Second Normal Form (2NF)
• Third Normal Form (3NF)
• Boyce Codded Normal Form (BCNF)
• Fourth Normal Form (4NF)
• Fifth Normal Form (5NF)
• Restrict Union Normal Form (RUNF)
• Project Join Normal Form (PJNF)
• Sixth Normal Form (6NF)

First Normal Form (1NF):  A table is said to be in 1NF if and only if a primary key is defined for that table and the table does not contain any multivalued columns.

Second Normal Form (2NF): A table is said to be in 2NF if and only if the table is in 1NF and no partial dependencies exist in the table.

Third Normal Form (3NF): A table is said to be in 3NF if and only if the table is in 2NF and no transient dependencies exist in the table.