What are the Different types of Normalization?
1566
05-May-2017
Updated on 18-Sep-2020
Manish Kumar
05-May-2017Normalization
Normalization is the way of removing redundant data from the database. Simply we can say that it is a process of organizing the columns and tables (relations) to reduce data redundancy.
1NF- According to the rule of 1NF an column of a table cannot contain more than one values. It should contain atomic values (single).
2NF-We can say a relation is in 2NF if it is in 1NF and no non-prime attribute is dependent .Non-prime is an attribute that is not a part of any candidate key.
3NF-We can say that a relation is in 3NF if it satisfies the two condition.
1-It should be in 2NF
2-All non-primary fields are dependent on the primary key.