Define Normalization and its types?
Ask by Anonymous User
Updated 19 Sep 2020
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.