Latest Activity In Study Groups

Join Your Study Groups

VU Past Papers, MCQs and More

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

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

RSS

© 2022   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service