Question: Consider a data warehouse for an airline which includes dimensions on passenger, time of the flight, and flight code. The data warehouse also has the

Consider a data warehouse for an airline which includes dimensions on passenger, time of the flight, and flight code. The data warehouse also has the measure fee, which refers to the amount for a flight for a passenger, and count, which counts how many times has the passenger flown with the airline.

1. Draw a star diagram for the data warehouse. Populate the dimension tables with attributes relevant to the application.

2. Starting with the base cuboid [day, passenger,flight code], which OLAP (online analytical processing) operations should be performed in order to list the total amount collected for a specific flight code (e.g. BA 208) over a specific year (e.g. 2019)?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Consider a data warehouse for an airline which includes dimensions on passenger, time of the flight, and flight code. The data warehouse also has the measure fee, which refers to the amount for a...

Transcribe the Text and the number of late flights so that the operations staff can anticipate where services need to be expedited. The ratio of the number of late flights to the total number of...

CASE 25 Southwest Airlines in 2014: Culture, Values, and Operating Practices Arthur A. Thompson John E. Gamble The University of Alabama Texas A&M University-Corpus Christi n 2014, Southwest Airlines...

HI GOOD AFTERNOON, IS IT POSSIBLE THAT I MAY GET SOME ASSISTANCE WITH THIS ASSIGNMENT. SEE ATTACHMENT INSTRUCTIONS ARE AS FOLLOWS: ONLY THE RELEVANT HISTORY IS IMPORTANT, IN TERMS OF A PROBLEM...

5-407-753 MARK JEFFERY Air France Internet Marketing: Optimizing Google, Yahoo!, MSN, and Kayak Sponsored Search Rob Griffin, senior vice president and U.S. director of search for Media Contacts, a...

Questions: 1. A) Analyze the how the E-Marketing strategies used to target customers in the light of changing preferences aided Air France to achieve its goals. Provide adequate reference from case...

As if dealing with economic cycles, fuel price volatility, organized labor, changing customer demographics, and increased competition was not enough... Delta CEO Ed Bastian assumed the role of Deltas...

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

U.S. Army Cost Benefit Analysis Guide 12 JANUARY 2010 Prepared by Office of the Deputy Assistant Secretary of the Army (Cost and Economics) Version 1.0 U.S. Army Cost Benefit Analysis Guide - V 1.0 2...

Find (a) The density (y) of y, (b) The conditional density fX|Y(x | y) of X given Y. Let fX,Y(x, y) = 5e-x-3y, for 0

What mass of H2 should be produced by the reaction of Al with 75.0 mL of 2.95M HCl?

Under GASB standards, a lease contract that has a maximum term of months is considered a short - term lease

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

2. Develop a program for effectively managing diversity.

7. What is coaching? Is there only one type of coaching? Explain.

8. Discuss reasons why many managers are reluctant to coach their employees.