---
title: "Explain different levels of normalization?"  
description: "Explain different levels of normalization?"  
author: "Anonymous User"  
published: 2019-09-24  
updated: 2020-09-15  
canonical: https://www.mindstick.com/interview/33633/explain-different-levels-of-normalization  
category: "mssql server"  
tags: ["database", "sql server", "sql"]  
reading_time: 1 minute  

---

# Explain different levels of normalization?

This is the way to eliminate redundant data like :

Reduces null value

Enables efficient indexing

1NF – Removes duplicated attributes, Attribute data should be atomic, and attribute should be the same kind.

2NF – Should be in 1NF and each non-key is fully dependent on the primary key.

3NF – Should be in 2NF and all the non-key attributes which are not dependent on the primary key should be removed. All the attributes which are dependent on the other non-key attributes should also be removed. Normalization is done in OLTP.

## Answers

### Answer by Anonymous User

This is the way to eliminate redundant data like :

Reduces null value

Enables efficient indexing

1NF – Removes duplicated attributes, Attribute data should be atomic, and attribute should be the same kind.

2NF – Should be in 1NF and each non-key is fully dependent on the primary key.

3NF – Should be in 2NF and all the non-key attributes which are not dependent on the primary key should be removed. All the attributes which are dependent on the other non-key attributes should also be removed. Normalization is done in OLTP.


---

Original Source: https://www.mindstick.com/interview/33633/explain-different-levels-of-normalization

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