We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

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

Looking for Something at Site? Search Below

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.

 



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


Views: 7488

Replies to This Discussion

not easy

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

zakki ako bho sol ki need hai????assignment tough hai is ka matlab???otherwise zakki ki assignments to sab se pahly ati

i think the fact table wil be like this.

Exam center   |pk //diemention

Exam Session |pk  //diemention

Mnth_Dim      |pk  //diemention

Total_ppr       |     //it is a fact.

any one got how to solve this assignment anyone??

zomi ap ne gain statemnt kia likhi?

Be@ch

I wrote gain statement as:

The total number of papers will be conducted in certain exam center in a certain session with in a certain time-period.

 IDEA FOR SOLUTION

There are four steps of dimensional modeling. First step is to identify the business process. Consider the “flight_Status_Aggregate” process described above. Apply the remaining steps of dimensional modeling to find out the fact and dimensional tables.

 

 

Solution:

 

Step-1: Identify Business Process

 

Business process:

 

“Flight_Status_Aggregate”:

 

This process involves following entities:

 

Step-2: Identify Grain           .

 

From the description of the given process and the sample output, the gain statement will be:

 

The total number of certain flight types with a certain departure status with in a certain time period.

 

The resultant table may have the structure like:

 

FlightType

Primary key

FlightStatus

Primary key

Month_Dim_ID

Primary key

TotalFligths

 

 

Step-3: Choose facts.

 

Here only involves one fact i.e. the TotalFlights. Note that this is the only attribute that keeps changing; all the other attributes remain constant for a certain grain.

 

Step-4: Identify Dimensions.

 

The dimensions will be FlightType, FlightStatus and Month_Dimension (date/duration). Note that these are part of a composite primary key that remains constant for a certain grain. So the possible fact table will be:

 

 

FlightType

Primary key

FlightStatus

Primary key

Month_Dim_ID

Primary key

TotalFligths:

 

 

And the dimension tables will be:

 

FlightADStatus

StatusID

StatusName

Description

01

OnTime

This status is set if flight departs or arrives as per schedule

02

Late

This status is set when the flight departs/arrives behind the specified schedule

03

NotDecided

This status is set when the flight is schedule first time. After the flight departs/arrives, the status is modified

For flight types, a master table with the name “Flight Type” is also defined with following structure and data:

 

Flight Type

FTypeID

FTypeName

Description

01

Direct

 

A flight is direct when it moves directly from source to destination location

02

Connected

A flight is connected with moves indirectly from source to destination involving multiple legs.

 

 

We suppose that the minimum date granularity is month so a date dimension with month granularity (as minimum) is defined as follows:

 

 

 

Month_dim

Month_Dim_ID

Month_Number

Month_Name

Year

001

1

Jan

2013

002

2

Feb

2013

003

3

Mar

2013

muhammad sadaqat ali

Exam Fall 2013, Spring 2013 is a diemention not a fact.

Total number of paper is a fact because it is changing within a certain time period. 

Plz correct if i am wrong.

sorry to say 

is me kia compelet solution hai kuch b to nai 

first step to hai nai ur baki step me ik ik line mein define kia hai ab is ka mai kia kro please tell me

so simple hai ye iss ko khayal se read karo

Muhammad Sadaquat Ali ,Allah blessed you health and wealth.....................I am unable to understand your solution...may you pls more guide

RSS

HELP SUPPORT

This is a member-supported website. Your contribution is greatly appreciated!

Latest Activity

gull hassan joined +M.Tariq Malik's group
2 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion BIF501 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More in the group BIF501 Bioinformatics II
2 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion MTH101 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More in the group MTH101 Calculus And Analytical Geometry
3 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion STA641 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More in the group STA641 - Statistical Packages and its Applications
4 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion STA641 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More in the group STA641 - Statistical Packages and its Applications
4 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion STA641 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More in the group STA641 - Statistical Packages and its Applications
4 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion STA641 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More in the group STA641 - Statistical Packages and its Applications
5 minutes ago
+M.Tariq Malik liked +M.Tariq Malik's discussion STA641 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More
5 minutes ago

Today Top Members 

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

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

.