CS614 ASSIGNMENT 1 SOLUTION 2023 | CS614 ASSIGNMENT 1 FALL 2023 | CS614 ASSIGNMENT 1 2023 | DATA WAREHOUSING | VuTech
Visit Website For More Solutions
www.vutechofficial.blogspot.com
KINDLY, DON’T COPY PASTE
Question No. 2:
Consider the following information about Department and Course tables.
Table1 (Master):
Header Size of the Department table: = 70 Bytes
Number of records stored in Department table: = 80000
Table2 (Detail):
Header size Course table: = 80 Bytes
Number of records stored in Course table: = 6000000
Suppose you have applied the pre-joining De-Normalization technique on ‘Department’ and ‘Course’ tables. Calculate the size of resultant table in Megabytes (MB), Gigabytes (GB) and Terabytes (TB). The reference column in these two tables is of 8 bytes.
Hint: There would be 6000000 records in De-normalized table.
Answer:
The deader of resultant De-normalized table = 70 + 80 – 8
= 142 bytes
The no of the records in De normalized table = 6000000
Size of the De normalized table = 142 * 6000000
= 852,000,000 Bytes
To convert bytes into MB we need to divide by (1000)2
= 852,000,000 / 1000000
= 852 MB
To convert bytes into GB we need to divide by (1000)3
= 852,000,000 / 1000000000
= 0.852 GB
To convert bytes into TB we need to divide by (1000)4
= 852,000,000 / 1000000000000
= 0.000852 TB