Normalization and Denormalization

Started by SeoDezin, 09-24-2020, 09:23:17

Previous topic - Next topic

SeoDezinTopic starter

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 ?


Lishmalinyjames

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.


saravanan28

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.
  •  

dark404

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.