We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read 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.
It should be clear that your assignment would not get any credit if:
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
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:
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”.
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.
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”.
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.
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.
Solution submitted in MS Word, CPP, PDF, Image or any other format will not acceptable.
Solution submitted through email will also not acceptable.
+ Click Here To Join also Our facebook study Group...How to Join Subject Study Groups & Get Helping Material?..
.+ 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?)
yaha par to koi bhi nhn ha ? na koi hint da raha ha na hi solution ki koi baat kar raha ha
Koi tu dhang ka idea share kr dy assignment k leay
Time is too short
Player, Match, Innings and Runs will be dimensions.. and what will be the title of FACT TABLE?
Thank you Sheraz Akram.
Kindly experts tell this solution is right.
Assignment instructions are clearly written in assignment file. You are only required to draw the star schema in solution file. You need to run the steps of dimension modeling in order to draw the star schema. You don’t need to show these steps in power point presentation file, you are only required to show the star schema in power point presentation file and explain your solution (star schema) with your audio voice. The demo or instructions as video file for using power point presentation with audio narration is given in download section. You can download the demo video file from the download section.
I am not sure about this solution... I am still confused about the facts table.. Only Total Runs attribute will be included or any other also?? And in Runs Dimension table which one primary key will be used and its attribute??
i also not satisfied
Audio narratation mein jo explaination deni hai. please koi to ose discuss karo. 4 steps batane hain Audio mein ya kuch aur
Tarik bhi jan time km reh gya hai help kro plzzzzzz
me to dosri sites k Id b bhol chuka ho k kahe or se solution dond sako.
Dear Students Don’t wait for solution post your problems here and discuss ... after discussion a perfect solution will come in a result. So, Start it now, replies here give your comments according to your knowledge and understandings....
i thnk sheraz this is not right solution bcz fact table should contain non key items