---
title: "What are all the different Normalization in DBMS?"  
description: "What are all the different Normalization in DBMS?"  
author: "Rahul Roi"  
published: 2019-05-06  
updated: 2020-09-16  
canonical: https://www.mindstick.com/interview/23504/what-are-all-the-different-normalization-in-dbms  
category: "database"  
tags: ["database", "sql server", "database schema"]  
reading_time: 2 minutes  

---

# What are all the different Normalization in DBMS?

The normal forms can be divided into 5 forms, and they are explained below -

**First Normal Form (1NF):.** It should remove all the duplicate columns from the table. The creation of tables for the related data and identification of unique columns.

**Second Normal Form (2NF):.** First fulfill all the requirements of normal form. Creating subsets and relationships of data in different tables between tables using primary keys.

**Third Normal Form (3NF):.**

It should meet all requirements of 2NF. Removing the columns which are not dependent on primary key constraints.

**Fourth Normal Form (3NF):.**

Complete all the requirements of the third normal form and it should not have multi-dependent dependencies.

## Answers

### Answer by Shrikant Mishra

Different Types of **Normalization** are:

**First Normal Form (1NF):** The relation is said to be in 1NF only when all the entities of the table contain unique or atomic values.

**Second Normal Form (2NF):** The relation is said to be in 2NF only if it is in 1NF and all the non-key attribute of the table is fully dependent on the primary key.

**Third Normal Form (3NF):** The relation is said to be in 3NF only if it is in 2NF and every non-key attribute of the table is not transitively dependent on the primary key.

### Answer by Rahul Roi

The normal forms can be divided into 5 forms, and they are explained below -

**First Normal Form (1NF):.** It should remove all the duplicate columns from the table. The creation of tables for the related data and identification of unique columns.

**Second Normal Form (2NF):.** First fulfill all the requirements of normal form. Creating subsets and relationships of data in different tables between tables using primary keys.

**Third Normal Form (3NF):.**

It should meet all requirements of 2NF. Removing the columns which are not dependent on primary key constraints.

**Fourth Normal Form (3NF):.**

Complete all the requirements of the third normal form and it should not have multi-dependent dependencies.


---

Original Source: https://www.mindstick.com/interview/23504/what-are-all-the-different-normalization-in-dbms

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