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 # 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:
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.
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.
.+ 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)
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