What are all the different Normalization in DBMS?

Rahul Roi

The normal forms can be divided into 5 forms, and they are explained below -

First Normal Form (1NF):.  It should remove all the duplicate columns from the table. The creation of tables for the related data and identification of unique columns.

Second Normal Form (2NF):. First fulfill all the requirements of normal form. Creating subsets and relationships of data in different tables between tables using primary keys.

Third Normal Form (3NF):.

It should meet all requirements of 2NF. Removing the columns which are not dependent on primary key constraints.

Fourth Normal Form (3NF):.

Complete all the requirements of the third normal form and it should not have multi-dependent dependencies.

Shrikant Mishra

 Different Types of Normalization are:

First Normal Form (1NF): The relation is said to be in 1NF only when all the entities of the table contain unique or atomic values.

Second Normal Form (2NF): The relation is said to be in 2NF only if it is in 1NF and all the non-key attribute of the table is fully dependent on the primary key.

Third Normal Form (3NF): The relation is said to be in 3NF only if it is in 2NF and every non-key attribute of the table is not transitively dependent on the primary key.