Define Normalization and its types?
1243
28-Mar-2018
Updated on 19-Sep-2020
Anonymous User
28-Mar-2018Normalization 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.