The flight data warehouse for travel agents consists of six dimensions: journey, departure (city), departure time, arriv

[answerhappygod]

The flight data warehouse for travel agents consists of sixdimensions: journey, departure (city), departure time, arrival,arrival time, and flight; and two measures: count() andcost-average(), where cost-average() keeps concrete costs at thelowest level but average costs at other levels.
Questionsa. Suppose the cube is fully realized. Starting with a cuboidalbasis [travelers, departures, departure times, arrivals, arrivaltimes, flights], what specific OLAP operations (e.g., roll-upflights to airlines) should perform to list the average fare permonth for each traveler which business flew American Airlines (AA)from Los Angeles in 2009?b. Suppose we want to calculate a data cube where the condition isthe minimum number of records is 10 and the average fare is morethan $500. Outline an efficient cube calculation method (based oncommon sense about the distribution of flight data).