I'm a professional writer and software developer with more than 10 years of experience. I have worked for a lot of businesses and can share sample works with you upon request. Chat me up and let's get started.....
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.
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.
Liked By
Write Answer
What are all the different Normalization in DBMS?
Join MindStick Community
You have need login or register for voting of answers or question.
Shrikant Mishra
06-May-2019Different 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.
Rahul Roi
06-May-2019The 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.