Database normalization, Advantages of Normalization, Disadvantages of Normalization

Database normalization, Advantages of Normalization, Disadvantages of Normalization

In this tutorial, we will learn about the followings;

  1. Database Normalization
  2. Advantages of Database Normalization
  3. Disadvantages of Database Normalization

What is database normalization?

Database normalization is a process in which we modify the complex database into the simpler database.

What are Advantages of normalization?

  1. Data consistency 
    • Data consistency means that the data is always real and it is not ambiguous.
  2. Data becomes nonredundant
    • Non-redundant means that only copy original copy of data is available for each user and for every time. There are no multiple copies of the same data for different persons. So when data is changed in one file and stay in one file. Then of course data is consistent and non-redundant. Here redundant is not same as a backup of data, both are different things.
  3. Reduce insertion, deletion and updating anomalies
    • Insertion anomaly is an anomaly that occurs when we want to insert data into the database but the data is not completely or correctly inserted in the target attributes. If completely inserted in the database then not correctly entered.
    • Deletion anomaly is an anomaly that occurs when we want to delete data in the database but the data is not completely or correctly deleted in the target attributes.
    • Updation anomaly is an anomaly that occurs when we want to update data in the database but the data is not completely or correctly updated in the target attributes.
  4. Database table compaction
    • When we normalize the database, we convert the large table into a smaller table that leads to data and table compaction. Compaction means to have the least and required size.
  5. Better performance
  6. Fast queries

What are disadvantages of normalization?

  1. Required experienced database designer
  2. Difficult and expansive
  3. Requires detailed database design