www.vustudents.ning.com

We non-commercial site working hard since 2009 to facilitate learning Read More. We can't keep up without your support. Donate.

# CS614 ASSIGNMENT NO 1 FALL 2021 Solution Required

Objective:
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.

Question 1 (Marks 10)​
​​​​​​​​​
Consider the following part of an ERD of Learning Management System.

For the given Entity Relationship Diagram (ERD) which de-normalization technique will be used? You are required to mention the name of the technique and also write one advantage of it, apply this technique on the given ERD and provide the resultant de-normalized table.

Note: As you already have a clear understanding of ERD and Normalization concepts. So, you can perform normalization at your own. Use these concepts to answer the first question.

Question 2 (Marks 10)
Consider the following information about Student and Course tables.
Table1 (Student):

Header size of student table: = 40 Bytes
Number of records stored in student table: = 30000

Table2 (Course):

Header size course table: = 70 Bytes
Number of records stored in course table: = 2000000

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 9 bytes.

Hint: The number of records in De-normalize table will 2000000.

Note: Deadline for assignment submission is I0th December 2021.

Views: 192

### Replies to This Discussion

Stay touched with this discussion, Solution idea will be uploaded as soon as possible in replies here before the due date.

# CS614 (Data Warehousing) Assignment No.1 Solution Fall 2021

1

## Latest Activity

4 hours ago
monaliza and waseem are now friends
6 hours ago
Zubii joined + M.Tariq Malik's group

### MTH401 Differential Equations

yesterday
Zubii joined + M.Tariq Malik's group

### CS502 Fundamentals of Algorithms

yesterday
Zubii joined + M.Tariq Malik's group

### CS501 Advance Computer Architecture

yesterday
yesterday
yesterday
Batool updated their profile
yesterday