Question

Database question:

In your own word, explain why do designers use Denormalization? What is the limitation of using Denormalization? Name and explain a better alternative approach than Denormalization.

Answer 1

Ans . PART -1 :-

Designers use denormalization as it is mainly used as, it can increase performance by using the previously normalized data. If, previous data are used which are redundant, it becomes easier to create new database or to divide the databases in parts which is necessary.

PART-2 :- The limitations of using Denormalization are :-

1. Data redundancy occupies more storage.
2. It increases the size of tables.
3. It does not maintain data integrity.
4. It makes difficult to write the insert and update code.

PART-3 :- The better alternative approach than Denormalization is data struct where , data would be redundant and can maintain integrity.