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

# CS614 Assignment No 01 Solution & Discussion Due Date: 16-11-2017

CS614 Assignment No 01 Solution & Discussion Due Date: 16-11-2017

CS614 - Data Warehousing Assignment No. 1 Solution Fall 2017 Due Date November 16, 2017

Semester Fall 2017

Data Warehousing– CS614

Total Marks: 20

Due Date: 16-11-2017

Objective:  This assignment has been designed to develop your ability to apply Normalization and De-Normalization Techniques

and principles to Normalize and 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. 3.                    The assignment file must be an MS Word (.doc) file format; Assignment will not be accepted in any other

format.

1. 4.                    Zero marks will be awarded to the assignment if copied (from other student or copied from handouts or

internet).

1.  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.

Question 1:

Consider the following schema and convert into second normal form.

Employee_Branch (Emp_id, EmpName, Designation, BranchID, BranchName, BranchLocation, Project)

The following functional dependencies exist for above table.

Emp_id, BranchID -> Project

Emp_id -> EmpName, Designation

BranchID -> BranchName, , BranchLocation

Question 2:

Consider the following four tables in normalized form. Your task is to De-Normalize these tables and to combine

them into a single table using demoralization techniques you have studied so far. You are required to show all

steps of De-Normalization.

Table 1:

Sid      Pid

S1       P1

S2       P2

Student

Name

Ali

Nida

CGPA

3.8

3.3

Project

Credit Hours

6

6

S3       P3

S4       P4

S5       P5

Shela         3.5

Saba

3.1

Saqib         3.7

6

6

6

Table 2:

Pid        Project Credit

Hours

P1         6

P2         6

P3         6

P4         6

P5         6

Project Title

Library Management System

School Management System

Hotel Management System

E-Voting System

Hospital Management System

Supervisor

Name

Dr. Aleem

Dr. Ashfaq

Dr. Faiza

Dr. Qasim

Dr. Ayeza

Table 3:

Sid      Pid       Visit#     Visit Date     Visit Time

S1       P1        1

S1       P1        2

S1       P1        3

S2       P2        1

S2       P2        2

S3       P3        1

S4       P4        1

S5       P5        1

10 Sep, 17     10: 00 am to 11:00 am

12 Sep, 17     11: 00 am to 12:00 pm

13 Sep, 17     10: 00 am to 11:00 am

12 Sep, 17     12: 00 pm to 2:30 pm

21 Sep, 17     2: 00 pm to 3:30 pm

10 Sep, 17     10: 00 am to 11:00 am

12 Sep, 17     2:00 pm to 5:00 pm

25 Sep, 17     1:00 pm to 2:00 pm

Table 4

Sid      Visit#

S1       1

Title

1

T1

12 Sep, 17

S1       2

S1       3

S2       1

S2       2

S3       1

S4       1

S5       1

2

3

1

2

1

1

1

T2

T3

T1

T2

T1

T1

T1

16 Sep, 17

20 Sep, 17

17 Sep, 17

21 Sep, 17

20 Sep, 17

25 Sep, 17

29 Sep, 17

Note: Deadline for assignment submission is 16th November 2017.

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: 5095

.

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

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

### Replies to This Discussion

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions. Read More>>

Note:-

For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.

For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.

&

.... How to Find Your Subject Study Group & Join ....

P.S:    Please always try to add the discussion in proper format title like “CS101 Assignment / GDB No 01 Solution & Discussion Due Date: ___________”

Projects (
Emp_id,
BranchID,
Project,
Primary Key(Emp_id, BranchID)
)
Emp_id BranchID Project Primary Key

Employee (
Emp_id,
EmpName,
Designation,
Primary Key(Emp_id)
)
Emp_id EmpName Designation Primary Key

Branch (
BranchID,
BranchName,
BranchLocation
Primary Key(BranchID)
)
BranchID BranchName BranchLocation Primary Key

Answer 2: De-Normalize Table 1 and Table 2

Sid, Pid, Student Name, CGPA, Project Credit Hours, Project Title, Supervisor Name

S1 P1 Ali 3.8 6 Library Management System Dr. Aleem

S2 P2 Nida 3.3 6 School Management System Dr. Ashfaq

S3 P3 Shela 3.5 6 Hotel Management System Dr. Faiza

S4 P4 Saba 3.1 6 E-Voting System Dr. Qasim

S5 P5 Saqib 3.7 6 Hospital Management System Dr. Ayeza

De-Normalize (Table 1, Table 2) and Table 3

Sid, Pid, Student Name, CGPA, Project Credit Hours, Project Title, Supervisor Name, Visit#, Visit Date, Visit Time

S1 P1 Ali 3.8 6 Library Management System Dr. Aleem 1 10 Sep, 17 10: 00 am to 11:00 am S1 P1 Ali 3.8 6 Library Management System Dr. Aleem 2 12 Sep, 17 11: 00 am to 12:00 pm S1 P1 Ali 3.8 6 Library Management System Dr. Aleem 3 13 Sep, 17 10: 00 am to 11:00 am S2 P2 Nida 3.3 6 School Management System Dr. Ashfaq 1 12 Sep, 17 12: 00 pm to 02:30 pm

S2 P2 Nida 3.3 6 School Management System Dr. Ashfaq 2 21 Sep, 17 02: 00 pm to 03:30 pm

S3 P3 Shela 3.5 6 Hotel Management System Dr. Faiza 1 10 Sep, 17 10: 00 am to 11:00 am S4 P4 Saba 3.1 6 E-Voting System Dr. Qasim 1 12 Sep, 17 02:00 pm to 05:00 pm

S5 P5 Saqib 3.7 6 Hospital Management System Dr. Ayeza 1 25 Sep, 17 01:00 pm to 02:00 pm

De-Normalize (Table 1, Table 2, Table 3) and Table 4

S1 P1 Ali 3.8 6 Library Management System Dr. Aleem 1 10 Sep, 17 10: 00 am to 11:00 am 1 T1 12 Sep, 17

S1 P1 Ali 3.8 6 Library Management System Dr. Aleem 2 12 Sep, 17 11: 00 am to 12:00 pm 2 T2 16 Sep, 17

S1 P1 Ali 3.8 6 Library Management System Dr. Aleem 3 13 Sep, 17 10: 00 am to 11:00 am 3 T3 20 Sep, 17

S2 P2 Nida 3.3 6 School Management System Dr. Ashfaq 1 12 Sep, 17 12: 00 pm to 02:30 pm 1 T1 17 Sep, 17

S2 P2 Nida 3.3 6 School Management System Dr. Ashfaq 2 21 Sep, 17 02: 00 pm to 03:30 pm 2 T2 21 Sep, 17

S3 P3 Shela 3.5 6 Hotel Management System Dr. Faiza 1 10 Sep, 17 10: 00 am to 11:00 am 1 T1 20 Sep, 17 S4

P4 Saba 3.1 6 E-Voting System Dr. Qasim 1 12 Sep, 17 02:00 pm to 05:00 pm 1 T1 25 Sep, 17

S5 P5 Saqib 3.7 6 Hospital Management System Dr. Ayeza 1 25 Sep, 17 01:00 pm to 02:00 pm 1 T1 29 Sep, 17

excuse me everyone i hv a question TABLE bnane hai or is it correct. some one help me and ans me.

Kia hum sirf sql query ki likhni hai na pura table bana ho ga

Abhi sirf normalization and D-normalization ko implement karna hai SQL is assignment a involve nahi hai.

Assignment No.1
Cs614
Projects (
Emp_id,
BranchID,
Project,
Primary Key(Emp_id, BranchID)
)
Emp_id BranchID Project Primary Key
Employee (
Emp_id,
EmpName,
Designation,
Primary Key(Emp_id)
)
Emp_id EmpName Designation Primary Key
Branch (
BranchID,
BranchName,
BranchLocation
Primary Key(BranchID)
)
BranchID BranchName BranchLocation Primary Key

Answer 2: De-Normalize Table 1 and Table 2
Sid, Pid, Student Name, CGPA, Project Credit Hours, Project Title, Supervisor Name
S1 P1 Ali 3.8 6 Library Management System Dr. Aleem
S2 P2 Nida 3.3 6 School Management System Dr. Ashfaq
S3 P3 Shela 3.5 6 Hotel Management System Dr. Faiza
S4 P4 Saba 3.1 6 E-Voting System Dr. Qasim
S5 P5 Saqib 3.7 6 Hospital Management System Dr. Ayeza
De-Normalize (Table 1, Table 2) and Table 3
Sid, Pid, Student Name, CGPA, Project Credit Hours, Project Title, Supervisor Name, Visit#, Visit Date, Visit Time
S1 P1 Ali 3.8 6 Library Management System Dr. Aleem 1 10 Sep, 17 10: 00 am to 11:00 am S1 P1 Ali 3.8 6 Library Management System Dr. Aleem 2 12 Sep, 17 11: 00 am to 12:00 pm S1 P1 Ali 3.8 6 Library Management System Dr. Aleem 3 13 Sep, 17 10: 00 am to 11:00 am S2 P2 Nida 3.3 6 School Management System Dr. Ashfaq 1 12 Sep, 17 12: 00 pm to 02:30 pm
S2 P2 Nida 3.3 6 School Management System Dr. Ashfaq 2 21 Sep, 17 02: 00 pm to 03:30 pm
S3 P3 Shela 3.5 6 Hotel Management System Dr. Faiza 1 10 Sep, 17 10: 00 am to 11:00 am S4 P4 Saba 3.1 6 E-Voting System Dr. Qasim 1 12 Sep, 17 02:00 pm to 05:00 pm
S5 P5 Saqib 3.7 6 Hospital Management System Dr. Ayeza 1 25 Sep, 17 01:00 pm to 02:00 pm
De-Normalize (Table 1, Table 2, Table 3) and Table 4
S1 P1 Ali 3.8 6 Library Management System Dr. Aleem 1 10 Sep, 17 10: 00 am to 11:00 am 1 T1 12 Sep, 17
S1 P1 Ali 3.8 6 Library Management System Dr. Aleem 2 12 Sep, 17 11: 00 am to 12:00 pm 2 T2 16 Sep, 17
S1 P1 Ali 3.8 6 Library Management System Dr. Aleem 3 13 Sep, 17 10: 00 am to 11:00 am 3 T3 20 Sep, 17
S2 P2 Nida 3.3 6 School Management System Dr. Ashfaq 1 12 Sep, 17 12: 00 pm to 02:30 pm 1 T1 17 Sep, 17
S2 P2 Nida 3.3 6 School Management System Dr. Ashfaq 2 21 Sep, 17 02: 00 pm to 03:30 pm 2 T2 21 Sep, 17
S3 P3 Shela 3.5 6 Hotel Management System Dr. Faiza 1 10 Sep, 17 10: 00 am to 11:00 am 1 T1 20 Sep, 17 S4
P4 Saba 3.1 6 E-Voting System Dr. Qasim 1 12 Sep, 17 02:00 pm to 05:00 pm 1 T1 25 Sep, 17
S5 P5 Saqib 3.7 6 Hospital Management System Dr. Ayeza 1 25 Sep, 17 01:00 pm to 02:00 pm 1 T1 29 Sep, 17

CS614_Assignment_1_Solution

Attachments:

Second question main de-normalized kr k aik table b banana hay.

yes

i need tht table maN

## Latest Activity

Bilal posted discussions
34 minutes ago
Seoul updated their profile
48 minutes ago
Attiqa Usman and Farhan Malik joined Virtual University of Pakistan
1 hour ago
Hira liked Hira's discussion EDU431 Quiz 2 Spring 2020
1 hour ago
Hira added a discussion to the group EDU431 Test Development & Evaluation

### EDU401 Quiz 2 Spring 2020

1 hour ago
Ezzah updated their profile
1 hour ago
+EH+ updated their profile
2 hours ago
zimal queen replied to + Ḱẚảḿḯ's discussion Mohabbat Ki Jhari
2 hours ago
Moona and Asad Waqas joined +M.Tariq Malik's group

### ENG201 Business and Technical English Writing

3 hours ago
Munna Bhai MBBS posted discussions
4 hours ago
Munna Bhai MBBS posted a status
4 hours ago
4 hours ago

1

2

3