List the average fare permonth for each business traveler

Assignment Help Basic Computer Science

Reference no: EM131224293

A flight data warehouse for a travel agent consists of six dimensions: traveler, departure(city), departure time, arrival, arrival time, and flight; and two measures: count, andavg fare, where avg fare stores the concrete fare at the lowest level but average fare atother levels.

(a) Suppose the cube is fully materialized. Starting with the base cuboid [traveller,departure, departure time, arrival, arrival time, flight], what specific OLAP operations(e.g., roll-up flight to airline) should one performin order to list the average fare permonth for each business traveler who flies American Airlines (AA) from L.A. in theyear 2004?

(b) Suppose we want to compute a data cube where the condition is that the minimumnumber of records is 10 and the average fare is over $500. Outline an efficient cubecomputation method (based on common sense about flight data distribution).

Reference no: EM131224293

Questions Cloud

Describe business etiquette and customs : Briefly describe business etiquette and customs in the following areas: - Business Greetings - Business Dress - Business Cards - Business Meetings - Business Negotiation.

Evolution of intermodal rail freight transport : What caused the evolution of intermodal rail freight transport from its forerunning period in the 1920s to present and the future growth of the industry?

Determine the polarities of the switch onstate currents : ECE 534 Homework. Solve the converter to determine the inductor currents and capacitor voltages. Determine the polarities of the switch onstate currents and offstate voltages. Do the polarities vary with duty cycle

Inherent in the option you did not choose : Would you seek to acquire a company within the European Union or outside of it? Why? Describe the advantages and disadvantages of the choice you made. Describe the advantages and disadvantages inherent in the option you did not choose.

List the average fare permonth for each business traveler : Suppose we want to compute a data cube where the condition is that the minimumnumber of records is 10 and the average fare is over $500. Outline an efficient cubecomputation method (based on common sense about flight data distribution).

Compensation and performance appraisals : Compare the factors being measured in job-based pay, skill-based pay, and competency-based pay. - What are the advantages and disadvantages to implementing each of these measurement systems?

Government expropriated the corporations property : An American commodity broker contracted with a Cuban corporation largely owned by United States residents to buy Cuban sugar. Thereafter, subsequent to the United States Government's reduction of the Cuban sugar quota, the Cuban Government expropriat..

Examine the results of the internal environmental scan : Examine the results of the internal environmental scan findings in the analysis. Examine the results of the external environmental scan findings in the analysis. Discuss the findings of the scans as they relate to relevant research.

Any trickle-down effects that the changes : From the e-Activity, predict the effects that changes in one industry could have on modifying and updating a system of the business. Include any trickle-down effects that the changes would have on the business as well. Provide specific examples to su..

User Account

All Pages