--- title: "What are the Different types of Normalization?" description: "What are the Different types of Normalization?" author: "Manish Kumar" published: 2017-05-05 updated: 2020-09-18 canonical: https://www.mindstick.com/interview/23237/what-are-the-different-types-of-normalization category: "database" tags: ["sql server"] reading_time: 2 minutes --- # What are the Different types of Normalization? **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. ## Answers ### Answer by Manish Kumar **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. --- Original Source: https://www.mindstick.com/interview/23237/what-are-the-different-types-of-normalization Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.