Introduction of Normalization

In this article I am going to explain about normalization in SQL.
  • 2093

Introduction

Normalization is used to organize the content of table. Normalization is a technique which eliminate redundancy and inconsistent dependency of data from database. Normalization makes database more flexible.

Basic Goal of normalization

  • Arrange data in database in to logical grouping.
  • Eliminate redundancy of data, it means minimizing the duplicate data in database.
  • Eliminate inconsistency of data 

There are seven normal forms

  1. First Normal Form
  2. Second Normal Form
  3. Third Normal Form
  4. Boyce-Codd Normal Form (BCNF)
  5. Fourth Normal Form
  6. Fifth Normal Form
  7. Domain Key Normal Form or Sixth Normal Form

To implement the the concept of  normalization in database it use some technique as functional dependency, multi value dependency and loss less join decomposition.


© 2018 DotNetHeaven. All rights reserved.