Data Normalization (DBMS)

 Normalization Concepts 

Database Normalization, or data normalization, is a technique to organize the contents of the table for transactional database and data warehouse. this includes creating tables and establising relationship between those tables according to rules designed both to protect data and make the database more flexible by eliminating two factors -

1. Redundancy and 
2. Inconsistent dependency 

Normalization is part of the successful database design, without normalization, database systems may be inaccurate, slow and inefficient and they might nor produce the data we expect .

         When we normalise the database, we have four goals :

1. Arranging data into logical groupings such that each group describes a small part of the whole 
2. Minimising the amount of duplicate data, called redundancy, stored in a database. 
3. Organising the data such that, when you modify it, you make the changes only in one place .
4. Bulding a database in which you can access and manipulate the data quickly and efficiently without compromising the integrity of the data in storage.