Google News
logo
SQL - Interview Questions
What are all the different normalizations?
The normal forms can be divided into some forms, and they are explained below :
 
First Normal Form (1NF): This should remove all the duplicate columns from the table. Creation of tables for the related data and identification of unique columns.
 
Second Normal Form (2NF): Meeting all requirements of the first normal form. Placing the subsets of data in separate tables and Creation of relationships between the tables using primary keys.
 
Third Normal Form (3NF): This should meet all requirements of 2NF. Removing the columns which are not dependent on primary key constraints.
 
Fourth Normal Form (4NF):Meeting all the requirements of third normal form and it should not have multi- valued dependencies.
Advertisement