---
title: "Define Normalization and its types?"  
description: "Define Normalization and its types?"  
author: "Anonymous User"  
published: 2018-03-28  
updated: 2020-09-19  
canonical: https://www.mindstick.com/interview/23369/define-normalization-and-its-types  
category: "database"  
tags: ["sql server"]  
reading_time: 2 minutes  

---

# Define Normalization and its types?

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 Anonymous User

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/23369/define-normalization-and-its-types

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.