Home Computer Science CS614 Assignment 1 Solution 2022

CS614 Assignment 1 Solution 2022

 

 

CS614 Assignment 1 Solution 2022

Total Marks: 20

 

Due Date: 09-06-2022

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.

 

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.

 

 

RELATED ARTICLES

Android-based E-Voting System | Mobile App

Android-based E-Voting System Project Domain/Category:   Android Application   Abstract/Introduction The mobile phone has become a versatile tool for communication, entertainment, education, gaming, and for commercial work in businesses...

The Zakat Automation System | Mobile App

The Zakat Automation System Mobile App Project Domain / Category Mobile Application Abstract / Introduction The Zakat Automation System Mobile App is focusing on developing a mobile application...

Android Application for Women’s Safety | Mobile Application

Project Domain / Category Mobile App / Cloud Computing   Abstract / Introduction Android application for women's safety is a mobile application developed with the primary objective of...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Android-based E-Voting System | Mobile App

Android-based E-Voting System Project Domain/Category:   Android Application   Abstract/Introduction The mobile phone has become a versatile tool for communication, entertainment, education, gaming, and for commercial work in businesses...

The Zakat Automation System | Mobile App

The Zakat Automation System Mobile App Project Domain / Category Mobile Application Abstract / Introduction The Zakat Automation System Mobile App is focusing on developing a mobile application...

Android Application for Women’s Safety | Mobile Application

Project Domain / Category Mobile App / Cloud Computing   Abstract / Introduction Android application for women's safety is a mobile application developed with the primary objective of...

Health Care App | Mobile Application | Android , Firebase

Health Care App Project Domain / Category Healthcare/Mobile App   Abstract / Introduction Most of the people don’t know which hospital and doctor is best for their specific disease....

Recent Comments