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








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


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


  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  











Credit Hours  



S3       P3  

S4       P4  

S5       P5  

Shela         3.5  



Saqib         3.7  




Table 2:  

Pid        Project Credit


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  



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  






12 Sep, 17          

S1       2  



S1       3  

S2       1  



S2       2  



S3       1  

S4       1  



S5       1  































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

+ Safety Guidelines for New + Site FAQ & Rules + Safety Matters

+ Important for All Members Take a Look + Online Safety

Views: 4775

See Your Saved Posts Timeline

Replies to This Discussion

kaha py uploud ki h apny table bna k

Tanle 3 ko horizantal kun nahi kr sakty

values primary ko dakhta hua data ma enter ho gi

Question 2 ka ek table banana hai aur i think yahan tak tek hai itna lamba likne ki zarorat nai hai. what do u say wasiq mahmood


es ka table nahi bana sakty kiya ya pir asy he submit karwani pary ge plzz koi bata day plzzz.matalb ye ka kiya es ko tabular form ma convert kar sakty hain plzzzz koi bat day?

Kindly itna tw hud b kr lia kry table tw bna lia kro ... ya phr asa kry k apni vu id r paswd b dy do upload b kra k dty hai ...

Khalid rehman 

 sorry to say kindly plz  hmary cmnt pary pir bat kary hm na ya kha tha ka kiya in ko table ma convert kar sakty ha ya nahi hm na just question pocha tha .or hame nahi zarort her ksi ko apni ID dati piroo or na hm ny ap  sa file mange ha is tera sa bat kar rhy ha jo  .or na he ap ny ye solve kar ka upload ki ha assignment so kindly hm sa is andaz ma bat karny ki zarort nahi 

me asy incomplete solution krta b ni hu... mny solve b kia hai r upload b kr dia hai me just yaha dekta rhta hu dusro k programming ka tariqa ...

acha that's good  kha pa kiya ha upload hame nahi dikha .

Question ma likha hai show all steps of De-Normalization mana jitna steps tha wo likh dia

you have to d-normalization only there is explanation given in handouts I see its explanation and I solve it

waqis mahmaood 

hm nay es ka 13 lec sunay hain lakin pir bhi hm sa ye solve nahi hui q k sir na kha tha denormalization me sab table ko ik table  ma convert karty hain effeciency ka lia. handout ma kony lec ka bat kar rahy ha in ap kiya kindly ap hme bata sakty hain?


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

Member of The Month

© 2018   Created by +~Malik~.   Powered by

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