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.
Join MindStick Community
You need to log in or register to vote on answers or questions.
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy.
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.