What is meant by normalization and denormalization?

1.	What is meant by normalization and denormalization?
Answer» NORMALIZATION is a process of REDUCING redundancy by organizing the data into multiple tables. Normalization leads to better usage of disk spaces and makes it easier to maintain the integrity of the database. Denormalization is the REVERSE process of normalization as it COMBINES the tables which have been normalized into a single table so that data retrieval becomes faster. JOIN operation allows us to create a denormalized form of the data by REVERSING the normalization.

Answer»

NORMALIZATION is a process of REDUCING redundancy by organizing the data into multiple tables. Normalization leads to better usage of disk spaces and makes it easier to maintain the integrity of the database.

Denormalization is the REVERSE process of normalization as it COMBINES the tables which have been normalized into a single table so that data retrieval becomes faster. JOIN operation allows us to create a denormalized form of the data by REVERSING the normalization.

Discussion

No Comment Found

Related InterviewSolutions

What is Data Warehousing?
What is meant by normalization and denormalization?
What is a lock. Explain the major difference between a shared lock and an exclusive lock during a transaction in a database.
Explain the difference between the DELETE and TRUNCATE command in a DBMS.
Explain the difference between intension and extension in a database.
Explain different types of relationships amongst tables in a DBMS.
What is meant by an entity-relationship (E-R) model? Explain the terms Entity, Entity Type, and Entity Set in DBMS.
Explain different levels of data abstraction in a DBMS.
What is meant by Data Warehousing?

What is meant by normalization and denormalization?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment