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

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

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

 

Question:

 

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

.

+ 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

pleasure

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

Dear

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 

RSS

Latest Activity

فقیہہ اقدس liked ٹمبکٹو's discussion محبّت اور دل - عشق مجازی
45 minutes ago
Choudary Nafees Ejaz commented on + M.Tariq Malik's group STAT404 Regression and Correlation
3 hours ago
Choudary Nafees Ejaz joined + M.Tariq Malik's group
3 hours ago
Choudary Nafees Ejaz liked + M.Tariq Malik's group STAT404 Regression and Correlation
3 hours ago
MUHAMMAD KASHIF replied to + M.Tariq Malik's discussion ENG506 World Englishes Assignment No 01 Fall 2019 Solution & Discussion in the group ENG506 World Englishes
5 hours ago
MUHAMMAD KASHIF joined + M.Tariq Malik's group
5 hours ago
+ M.Tariq Malik replied to ayesha's discussion CS614 Assignment NO.1 Fall 2019 Solution&Discussion Due date: 14 Nov 2019 in the group CS614 Data Warehousing
5 hours ago
+ M.Tariq Malik replied to ayesha's discussion CS614 Assignment NO.1 Fall 2019 Solution&Discussion Due date: 14 Nov 2019 in the group CS614 Data Warehousing
5 hours ago
Profile IconKhadija Naveed, Muhammad Abdullah, maha khan and 6 more joined Virtual University of Pakistan
5 hours ago
MUHAMMAD KASHIF replied to + M.Tariq Malik's discussion ENG505 Language Learning Theories Assignment No 01 Fall 2019 Solution & Discussion in the group ENG505 Language Learning Theories
5 hours ago
MUHAMMAD KASHIF joined + M.Tariq Malik's group
5 hours ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS201 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group CS201 Introduction to Programming
5 hours ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion PAK301 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 21-11-2019 in the group PAK301 Pakistan Studies
5 hours ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion PAK301 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 21-11-2019 in the group PAK301 Pakistan Studies
5 hours ago
+ M.Tariq Malik replied to Rana Ali's discussion EDU201 Learning Theories Assignment No 01 Fall 2019 Solution & Discussion in the group EDU201 Learning Theories
5 hours ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion HRM624 Conflict Management Assignment No 01 Fall 2019 Solution & Discussion Due Date: 21-11-2019 in the group HRM624 Conflict Management
5 hours ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion HRM624 Conflict Management Assignment No 01 Fall 2019 Solution & Discussion Due Date: 21-11-2019
5 hours ago
+ M.Tariq Malik added a discussion to the group HRM624 Conflict Management
5 hours ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS723 Probability and Stochastic Processes Assignment No 01 Fall 2019 Solution & Discussion in the group CS723 Probability and Stochastic Processes
5 hours ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion CS723 Probability and Stochastic Processes Assignment No 01 Fall 2019 Solution & Discussion
5 hours ago

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

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