Web Administration > Databases

Normalization and Denormalization


There are two terms used in database designing are normalization and de-normalization. Any one who can guide me the concept of both terms and when they are applied ?

Normalization is used to remove redundant data from the database and to store non-redundant and consistent data into it.  On another hand during Denormalization data is integrated into the same database and hence the number of tables to store that data increases in number.

Normalization is the technique of dividing the data into multiple tables to reduce data redundancy and inconsistency and to achieve data integrity. ... Redundant data is eliminated when normalization is performed whereas denormalization increases the redundant data. Normalization increases the number of tables and joins.


[0] Message Index

Go to full version