Chapter 5, Problem 5.5RQ

Explanation of Solution

Denormalization:

A process of combining two relations into one new relation is called as “Denormalization”.

Example:

Consider the example of denormalization is as follows:

Normalized table:

Sales:

Sales_id	Sales_date	Sales_person

Product:

Tax_id	Sales_id	Itm_id	Item_quantity	Sales_rs

After denormalization the “Product” table is as follows:

Tax_id

Sales_date

Sales_person

Sales_id

Item_id