Seo Forum

Web Administration => Databases => Topic started by: SeoDezin on 09-24-2020, 09:23:17

Title: Normalization and Denormalization
Post by: SeoDezin on 09-24-2020, 09:23:17
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 ?
Title: Re: Normalization and Denormalization
Post by: Lishmalinyjames on 03-29-2021, 04:25:17
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.
Title: Re: Normalization and Denormalization
Post by: saravanan28 on 04-12-2021, 05:41:22
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.