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 

KINDLY, DON’T COPY PASTE
SUBSCRIBE, SHARE, LIKE AND COMMENTS FOR MORE UPDATES
SEND WHATSAPP OR E-MAIL FOR ANY QUERY
0325-6644800
kamranhameedvu@gmail.com
Visit Website For More Solutions
www.vutechofficial.blogspot.com