We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

www.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

# Data Warehousing– CS614_Assignment No. 1 (Graded) _Due Date: 22-11-2018

 Assignment No. 1 (Graded) Semester Fall 2018 Data Warehousing– CS614 Total Marks: 20   Due Date: 22-11-2018 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 student or copied from handouts or internet). 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 7-8. Question:                                                                                                                                                                            Consider the following part of an ERD of Hotel Reservation System.     Table Collapsing and Pre-Joining are two important techniques of de-normalization. You are required to perform following tasks: Task 1: Identify all such relations from above given ERD on which Table Collapsing technique can be applied. After that apply table collapsing techniques on tables having such relationships.   Task 2: Identify all such relations from above given ERD on which Pre-joining technique can be applied. After that apply table collapsing techniques on tables having such relationships.     Note: Deadline for assignment submission is 22 November 2018.   Wish you best of Luck!

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?

Views: 2006

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

Attachments:

### Replies to This Discussion

primary keys 2 br lgani hein?

Reference nhy Foriegn hoti ha

VU ID:                                     bc123456789

ANS:

1:   Table collapsing will be applied on the table having one to one relation ship so it will be look like this

1.                         GUEST   AND RESERVATION
2.                         ROOM AND BILL

2:    Pre-joining will be applied on table having one to many relationship so it will look like this

I think, final table is only one,

## Latest Activity

2 minutes ago
3 minutes ago
5 minutes ago
Ateeqa replied to +++A++R+++'s discussion چلتی بس میں نکاح
7 minutes ago
13 minutes ago
13 minutes ago
14 minutes ago
Alone Struggler liked + ! ! ! ! ! branded billi ! ! +'s discussion mehboob
14 minutes ago
16 minutes ago
Alone Struggler liked + ! ! ! ! ! branded billi ! ! +'s discussion yadeiin
16 minutes ago
23 minutes ago
35 minutes ago

1

2

3