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

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

Study Groups By Subject code Wise (Click Below on your university link & Join Your Subject Group)

[ + VU Study Groups Subject Code Wise ]  [ + COMSATS Virtual Campus Study Groups Subject Code Wise ]

Looking For Something at vustudents.ning.com?Search Here

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 

 

Assignment No. 1 (Graded) 

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  


Task #        Task  

Title  

1  

T1  


Task  

Deadline  

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! 

Share This With Friends......


How to Find Your Subject Study Group & Join.

Find Your Subject Study Group & Join.

+ Click Here To Join also Our facebook study Group.


This Content Originally Published by a member of VU Students.

+ Prohibited Content On Site + Report a violation + Report an Issue


Views: 4580

See Your Saved Posts Timeline

Replies to This Discussion

Please Discuss here about this assignment.Thanks

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.

Or visit this link 

Click Here For Detail.

&

.•°How to Download past papers from study groups°•.

 

Please Click on the below link to see…

.... 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: ___________”

Answer 1:
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

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

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
Answer 1: 
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.
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
Sid ,Pid, Student Name, CGPA, Project Credit Hours, Project Title, Supervisor Name, Visit#, Visit Date, Visit Time, Task#, Task Title, Task Deadline
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

I already upload it see page 1

RSS

Forum Categorizes

Job's & Careers (Latest Jobs)

Admissions (Latest Admissons)

Scholarship (Latest Scholarships)

Internship (Latest Internships)

VU Study

Other Universities/Colleges/Schools Help

    ::::::::::: More Categorizes :::::::::::

Today Top Members 

Member of The Month

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

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