CS614 Assignment 1 Solution 2022



CS614 Assignment 1 Solution 2022

Total Marks: 20


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. 


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 

Question 1  (Marks 10)                                                                                                                                 

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.



Leave a Reply

Your email address will not be published. Required fields are marked *