CS614 Assignment 1 Solution 2022

CS614 Assignment 1 Solution 2022

Due Date: 09-06-2022

This assignment has been designed to develop your ability to apply De-Normalization Techniques and principles to De-Normalize data/tables. 

Instructions:

Please read the following instructions carefully before solving & submitting the  assignment:

1.      The assignment will not be accepted after due date.

2.      Zero marks will be awarded to the assignment that does not open or the file is corrupt.

3.      The assignment file must be an MS Word (.doc) file format; Assignment will not be accepted in any other format.

4.      Zero marks will be awarded to the assignment if copied (from other students, internet or any source).

5.      Zero marks will be awarded to the assignment if the Student ID is not mentioned in the assignment file.

For any query about the assignment, contact only at CS614@vu.edu.pk

Please do not post queries related to assignment on MDB.

Note: The assignment covers lectures 1-9.

CS614 Assignment 1 Solution 2022 File 

Below Entity Relationship Diagram (ERD) is an illustration of some specific scenario related with construction project.

For the given ERD which de-normalization technique will be used? You are required to mention the name of the technique, apply this technique on the given ERD and provide the resultant de-normalized table.

Note: You have a clear understanding of ERD and Normalization concepts. So, you can do normalization by your own.  Use these concepts to answer the first question.

Question 2  (Marks 10)

Consider the following information about Project and Manager tables.

Table1 (Master):  

Header Size of the Project table:                    =   30 Bytes

Number of records stored in student table:    =   40000

Table2 (Detail):  

Header size Manager table:                               =   50 Bytes

Number of records stored in course table:     =   3000000

Suppose you have applied the pre-joining De-normalization technique on given tables. You are now required to 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: The number of records in De-normalize table will 3000000.