Why normalization is important in data modelSolutionNormaliz

Why normalization is important in data model?

Solution

Normalizaion refers to the process of decomposing data to reduce the redundancies and other anamolies which lead to costly operations of insertion/deletion of data in the model. Now it is very important because it ensures that each row of data is stored only once which helps avoid data anamolies. For instance, Lets say you have multiple copies of same data at multiple places in your model/table. And if you do not remove this redundacy, then it may happen that you may update some information at one place but not at all places. This will lead your model inconsistent. So normalization ensures that this does not happen.

Broadly, we can say normalization is important in data model because of following reasons -

1. It minimizes data redundancies

2. It minimizes inserting/updating/modifying/deleting (data) anamolies

3. It reduces the need to restructure the model as new types of data is introduced, thus increasing the life of the model.

4. It also helps in making the model for informative and logical to the users

5. It ensures consistency