Normalization


 What is, definition of Normalization, Benefits of normalization, real world scenario or live project work on normalization, purpose of normalization is to minimize redundancy and dependency  .

Define Normalization?

Normalization is the process of designing database tables in a way that makes for efficient use of disk space and that allows the efficient manipulation and updation of data.
The main purpose of normalization is to minimize redundancy and dependency, which involves dividing large tables into smaller tables and defining relationships between them. 
Normalization isolates data, so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.

Multiple benefits of Normalization:
  • Elimination of data redundancy and dependency in database
  • Improved performance
  • Query optimization 
  • Efficient manipulation and updation of data (faster updates due to less number of columns in one table)
  • Index improvements