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

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

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! 

+ Click Here To Join also Our facebook study Group.

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

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

See Your Saved Posts Timeline

Views: 4997

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?


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

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