Last updated:9/16/2020 3:20:40 AM
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.
© Copyright © 2010 - 2021 MindStick Software Pvt. Ltd. All Rights Reserved
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.