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

Data warehousing (CS614)

Assignment # 02 (GRADED)

                   Total marks = 20

                                                                                                                  Deadline Date: 08-june-2015

Please carefully read the following instructions before attempting the assignment.

Assignment Guidelines

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 internet or any other source.

 

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

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

3)      Assignment is graded and will contribute marks in final grades

 

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


Please refer to case study given in assignment#01:

 

ERD

 

 

Consider the process “Player_performance”. The entities which are involved in the process are given in above ERD. The process has the following information;

“ALI made 55 runs in first innings of first test match”.

“Wasim made 80 runs in first innings of second test match”.

“Arslan made 105 runs in second innings of first test match”.

Question:

You have studied four steps which are involved in dimensional modeling. First step is to identify the business process. Consider the process “Player_performance” described above. Apply the remaining steps of dimensional modeling to find out the grain, facts and dimensions and then model a simplified star schema from it.  

Note:

You need to run the three steps i.e. grain, facts and dimensions of dimension modeling at your own. You have to only draw the star schema in Solution file as mentioned in “Solution-Template.ppt”.

 

Submission:

You are required to submit your solution as an audio presentation in power point file through LMS. A template file is attached. You need to use provided “Solution-Template.ppt” file for your presentation.

Prepare presentation slides in following way.

  1. In first slide enter your name, VU-ID and MS Office version that you used as given in template.
  2. In second slide show the star schema that you have drawn with help of dimension modeling and record audio narration which will explain your solution (Star schema). You need to give very brief explanation of solution. While recording audio narration, don’t forget to speak your name and VU-ID in the beginning. 

Guidelines for Recording Audio Narration:

You have to make a presentation file with audio narration to explain your solution.

The guidelines about how you will attempt your solution are given below.

  1. You have to give solution on the template that is attached with assignment file.
  2. Record your presentation using the method given in demo video file. You can download the demo video file for audio presentation from the download section (http://vulms.vu.edu.pk/Courses/CS614/Downloads/Demo%20video%20file%...). If you are using Office 2003 then watch “Audio Narration Recording Office 2003” video and for Office 2007 use “Audio Narration Recording Office 2007” video file. 
  3. The total time for audio recording should not exceed 5 minutes.
  4. Double check your recorded narration is working fine and voice is clear for listening before submission. For this purpose you can run your presentation on multiple computers.
  5. If your audio is not properly recorded, audio is not clear or submitted file is corrupt then you will receive zero marks.

Note:

Solution submitted in MS Word, CPP, PDF, Image or any other format will not acceptable.

Solution submitted through email will also not acceptable. 

 

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

.

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

Attachments:

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.

Helpful Video Tutorial:

To Understand dimensional modeling, star schemas, designing dimensionshttp://goo.gl/PLxY1E

Data Warehousing Dimensional Modeling :

- Check this Guide: http://goo.gl/nTMemx

Dear Students!

 

Data warehousing (CS614)

Assignment # 02 (GRADED)

                   Total marks = 20

                                                                                                                  Deadline Date: 08-june-2015

Please carefully read the following instructions before attempting the assignment.

Assignment Guidelines

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 internet or any other source.

 

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

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

3)      Assignment is graded and will contribute marks in final grades

 

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

 

Please refer to case study given in assignment#01:

 

ERD

 

 

Consider the process “Player_performance”. The entities which are involved in the process are given in above ERD. The process has the following information;

“ALI made 55 runs in first innings of first test match”.

“Wasim made 80 runs in first innings of second test match”.

“Arslan made 105 runs in second innings of first test match”.

Question:

You have studied four steps which are involved in dimensional modeling. First step is to identify the business process. Consider the process “Player_performance” described above. Apply the remaining steps of dimensional modeling to find out the grain, facts and dimensions and then model a simplified star schema from it.  

Note:

You need to run the three steps i.e. grain, facts and dimensions of dimension modeling at your own. You have to only draw the star schema in Solution file as mentioned in “Solution-Template.ppt”.

 

Submission:

You are required to submit your solution as an audio presentation inpower point file through LMS. A template file is attached. You need to use provided “Solution-Template.ppt” file for your presentation.

Prepare presentation slides in following way.

  1. In first slide enter your name, VU-ID and MS Office version that you used as given in template.
  2. In second slide show the star schema that you have drawn with help of dimension modeling and record audio narration which will explain your solution (Star schema). You need to give very brief explanation of solution. While recording audio narration, don’t forget to speak your name and VU-ID in the beginning. 

Guidelines for Recording Audio Narration:

You have to make a presentation file with audio narration to explain your solution.

The guidelines about how you will attempt your solution are given below.

  1. You have to give solution on the template that is attached with assignment file.
  2. Record your presentation using the method given in demo video file. You can download the demo video file for audio presentation from the download section (http://vulms.vu.edu.pk/Courses/CS614/Downloads/Demo%20video%20file%...). If you are using Office 2003 then watch “Audio Narration Recording Office 2003” video and for Office 2007 use “Audio Narration Recording Office 2007” video file. 
  3. The total time for audio recording should not exceed 5 minutes.
  4. Double check your recorded narration is working fine and voice is clear for listening before submission. For this purpose you can run your presentation on multiple computers.
  5. If your audio is not properly recorded, audio is not clear or submitted file is corrupt then you will receive zero marks.

Note:

Solution submitted in MS Word, CPP, PDF, Image or any other format will not acceptable.

Solution submitted through email will also not acceptable. 

 

Please guide

yar cs614 ka solution

 hi dae do 

Plz explain it Rosey

share more ideas....

Lecture konsa ha ?

13

sirf 13

RSS

Latest Activity

♦_"Tooba"_♦ commented on Biya's blog post Rat Ki Tanhai Main....
6 minutes ago
♦_"Tooba"_♦ liked + Iuuoɔǝut+'s blog post A Brief History of HTML
8 minutes ago
♦_"Tooba"_♦ liked + ! ! ! ! ! !blaire's blog post غار سجدہ
8 minutes ago
♦_"Tooba"_♦ commented on + ! ! ! ! ! !blaire's blog post غار سجدہ
9 minutes ago
♦_"Tooba"_♦ liked Whispering Soul's discussion Mamu :D
10 minutes ago
♦_"Tooba"_♦ liked Biya's discussion Waqat Dolat Rishty. . .
10 minutes ago
♦_"Tooba"_♦ replied to Biya's discussion Waqat Dolat Rishty. . .
11 minutes ago
♦_"Tooba"_♦ liked + Iuuoɔǝut+'s discussion Mujhe shakh shakh sy torna ................
12 minutes ago
♦_"Tooba"_♦ replied to + Iuuoɔǝut+'s discussion Mujhe shakh shakh sy torna ................
12 minutes ago
♦_"Tooba"_♦ liked Biya's discussion Khoob Sorat Bat. . . . .
20 minutes ago
彡JK彡 ❤️ replied to 2.O's discussion Aunties Always Poke Me :P :P
42 minutes ago
2.O posted a discussion
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked Biya's discussion Waqat Dolat Rishty. . .
5 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked Whispering Soul's discussion Mamu :D
5 hours ago
Rana Shoaib updated their profile
5 hours ago
+ ! ! ! ! ! !blaire liked + Iuuoɔǝut+'s profile
6 hours ago
Biya liked + Iuuoɔǝut+'s blog post A Brief History of HTML
6 hours ago
+ ! ! ! ! ! ! ! ! ! AG replied to Biya's discussion Waqat Or Samajh
6 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked Biya's discussion Waqat Or Samajh
6 hours ago
+ ! ! ! ! ! ! ! ! ! AG replied to Biya's discussion Khoob Sorat Bat. . . . .
6 hours ago

Today Top Members 

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

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