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.
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.
Header size of student table: = 40 Bytes
Number of records stored in student table: = 30000
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.
We are user-generated contents & non-commercial site since 2009. All product, videos, pictures & others contents on site don't seem to be beneath our Copyrights & belong to their respected owners & freely available on public domains. All Contents on site are for personal & non-commercial use.We believe in Our Policy & do according to them. If Any content is offensive in your Copyrights then please email at email@example.com with copyright detail & We will happy to remove it immediately.