@zareen said in CS614 Assignment 2 Solution and Discussion:
Calculate the total space reserved in memory using normalization
Q. 1. Calculate the total space reserved in memory using normalization1. Calculate the total space reserved in memory using normalization
Q. 1 Solution:
Total space used
= 10 (Million records) x 40 (Bytes header) + 110 (Million records) x 70 (Bytes header)
= (1000000040) + (11000000070)
=8,100,000,000
= 8.1 GB
Q. 2. Calculate the total space reserved in memory after de-normalization using pre-joining technique
Q. 2 Solution:
Total space used
= (70 + 40 – 10) (Bytes header) x 110 (Million records)
=100*110000000
=11,000,000,000
= 11 GB