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


+ Link For Assignments, GDBs & Online Quizzes Solution


+ 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

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

CS614 Data Warehousing Assignment No.2 (Graded) Spring 2014 Due Date: 26 May 2014

Data warehousing (CS614)

Assignment # 2 (GRADED)

Total marks = 20

                                                                                       Deadline Date = 26/05/2014

Please carefully read the following instructions before attempting the assignment.


Rules for Marking

It should be clear that your assignment would not get any credit if:


  • The assignment is submitted after due date.
  • The submitted assignment does not open or file is corrupt.
  • The assignment is copied. Note that strict action would be taken if the submitted assignment is copied from any other student. Both students will be punished severely.


1)      You should consult recommended books to clarify your concepts as handouts are not sufficient.

2)      You are supposed to submit your assignment in .doc format. Any other formats like scan images, PDF, Zip, rar, bmp, docx etc will not be accepted

3)      You are advised to upload your assignment at least two days before Due date.

4)      This assignment file comprises of Two (2) pages.



Important Note: 


Assignment comprises of 20 Marks. Note that no assignment will be accepted after due date via email in any case (whether it is the case of load shedding or emergency electric failure or internet malfunctioning etc.). Hence, refrain from uploading assignment in the last hour of the deadline, and try to upload Solutions at least 02 days before the deadline to avoid inconvenience later on.


For any query please contact: CS614@vu.edu.pk

Assignment No. 2

Consider the business process “exams_sessions_papers_aggregate”. The entities involved in the process are shown in above portion of ERD. The process calculates the information that can be sampled as follows:


“Totally 100 papers were conducted in exam center “VU001” in morning session in Fall 2013 exam”.


“Totally 110 papers were conducted in exam center “VU002” in evening session in Spring 2013 exam”.


“Totally 150 papers were conducted in exam center “VU001” in evening session in Fall 2013 exam”.




There are four steps of dimensional modeling. First step is to identify the business process. Consider the “exams_sessions_papers_aggregate” process described above. Apply the remaining steps of dimensional modeling to find out the fact and dimensional table(s).


Note: You are required to show these steps in solution as well.


+ How to Follow the New Added Discussions at Your Mail Address?

+ 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?

See Your Saved Posts Timeline

Views: 7466


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

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

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

is that correct solution.plz Tariq Bhai bataye?

I think fairy wala correct solution hai thanks fairy


is there anyone who have exact idea of this ?? coz it seems to be any proper guidance... 

ye correct ha bilkul. samjho. and apny ilfaz mai bna k bejh do. Or time nahi bacha waste krny ka.

Hello Mr Tariq Malik,

why you misguide all CS614 students. you post a wrong solution . you just want to promote your website . how can you say that your posted  solution is correct? Dear all here is a wrong fact table so be care-full

Usman Saqib kisi ku b kabi correct solution nai kaha gaya hai.. ok 

or rahi bat share ki tu discussion ka purpose hi yahi hai..

or jis nay parha hu ga or jis ka damgh hu ga ius ku pata hu ga k kahan say kia chiz right hai or kia ghalat..

or just itna bul dayna k right wrong sab bul daytay han.. or muhammad sadaqat ali nay theak kaha hai ...agar itna hai tu ap bata du..


Time of day Primary Key
Session Primary Key
Exam center Primary key

above mean fact table have composite Primary key which is a combination of 3 columns so this  is 100% wrong  in actual these three columns have many to one relation its mean these are all FK and all   3 dimensions table have one pk which have one to many relation with fact table ...

kindly upload the complete solution 


Latest Activity

Today Top Members 

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

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