Differences Between De-Normalization And Normalization

1395 Words6 Pages
Question No.1 a) Describe the difference between De-normalization and normalization with the help of examples. Answer: Normalization and De-normalization are two processes to optimize the performance of database. Normalization is the process of creating database that is structurally consistent having no or minimum redundancy however sometimes fully normalized database does not provide maximum processing efficiency. So when performance does matter, one prefer De-normalized database. Following are the major differences between the two processes. 1. Normalization is the process of dividing the large tables into two to remove the redundancies and to achieve data integrity. While De-normalization is the reverse of normalization, in which one combines two different tables into one table to achieve efficiency i.e. fast retrieval of data. 2. Normalization removes redundancy that is it eliminates repeating groups and puts them in a separate table. While in De-normalization data redundancy that is duplication of data may be found. 3. Normalization maintains data integrity, it means that deletion, and updating or insertion of data does not create any mismatch in the relationship of tables while de-normalized database one has to care while inserting, deleting or updating all records as there is duplicate data in a single table. So failing to do so will create integrity issues. 4. Normalization increases the number of tables and then joins them but de-normalization reduces the number of

More about Differences Between De-Normalization And Normalization

Open Document