Normalization

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.