Normalizing and Denormalizing Data

After designing a database, it is important to ensure that the data in the table is consistent and relevant. Normalization is a process of reducing the redundancy of data in a relational database. The reversal of normalization to improve performance due to some factors is called Denormalization.



Redundancy means repetition of data. Redundancy increases the time involved in adding, updating, and deleting data. It also increases the utilization of disk space and hence, disk I/O increases.