---
title: "What is  Normalization in Database ?"  
description: "What is  Normalization in Database ?"  
author: "Sanat Shukla"  
published: 2018-09-21  
canonical: https://answers.mindstick.com/qa/50060/what-is-normalization-in-database  
category: "database"  
tags: ["mssql server", "database"]  
reading_time: 2 minutes  

---

# What is  Normalization in Database ?

Why [Normalization](https://www.mindstick.com/articles/438/what-is-normalization) [concept](https://www.mindstick.com/blog/79/routing-concept-in-dot-net) is used in the database.

## Answers

### Answer by Arti Mishra

## “Normalization in Database”

Normalization is a **process of organizing the huge amount of data into a database** and **reduces the dependency of relation table.** It **divides the large table into multiple sub-parts** and links them as a relation.

\

**Types of Normalization**

- First normal form(1NF)
- Second normal form(2NF)
- Third normal form(3NF)
- Boyce & Codd normal form (BCNF)
- Fourth normal form(4NF)
- Fifth normal form(5NF)

\
**First Normal Form(1NF) :** 1NF describe the concept of **atomic value**, I mean an **attribute of a column can’t have multiple values.** **\** ![What is  Normalization in Database ?](https://answers.mindstick.com/questionanswer/2d45441c-2a1f-4186-8ce4-76ad75ce4294/images/e3815d5d-6ce6-4e9a-8482-b3d81a471624.gif) **\** **\** \
**Second Normal Form(2NF) :** A table is said to be in 2NF if follow these conditions- Table must follow the rule of 1NF (First normal form) and **all attributes are dependent on a primary key attribute.** **\** ![What is  Normalization in Database ?](https://answers.mindstick.com/questionanswer/2d45441c-2a1f-4186-8ce4-76ad75ce4294/images/30a8a086-fea6-4308-a6b0-9b62b9068faa.gif) **\** \
\
**Third Normal Form (3NF) :** In 3NF, a table must follow the rule of 2NF and **no any transitive dependency will exist.** **\** ![What is  Normalization in Database ?](https://answers.mindstick.com/questionanswer/2d45441c-2a1f-4186-8ce4-76ad75ce4294/images/594317b5-0bec-4757-97da-ec0fd092c367.gif) **\** **\** \
**Boyce & Codd normal form (BCNF) :** BCNF is the extension of 3NF and for **every functional dependency A->B, A should be the super key of the table.** **\** ![What is  Normalization in Database ?](https://answers.mindstick.com/questionanswer/2d45441c-2a1f-4186-8ce4-76ad75ce4294/images/f5f532d3-7877-416a-8ccb-17940993c9e2.jpeg) **\** \
\
**Fourth Normal Form(4NF) :** In 4NF, a table must follow the rule of BCNF and **no any multi-valued dependency will exist.** **\** ![What is  Normalization in Database ?](https://answers.mindstick.com/questionanswer/2d45441c-2a1f-4186-8ce4-76ad75ce4294/images/187acc17-8d2a-49a5-b43f-a9f29b704e1f.png) **\** ![What is  Normalization in Database ?](https://answers.mindstick.com/questionanswer/2d45441c-2a1f-4186-8ce4-76ad75ce4294/images/bc6bca31-b061-455f-a6e5-d0ba3042a4f8.png) \
**Fifth Normal Form (5NF) :** In 5NF, a table must follow the rule of 4NF and **no any join dependency will be allowed.** **\** ![What is  Normalization in Database ?](https://answers.mindstick.com/questionanswer/2d45441c-2a1f-4186-8ce4-76ad75ce4294/images/eb67ad82-068b-40de-8aef-3f3c6b2982d8.png) **\** **\** **\** \
**"Thanks!!! for Reading"**


---

Original Source: https://answers.mindstick.com/qa/50060/what-is-normalization-in-database

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