Suppose that a data warehouse consists of the four dimensions, date, spectator, location, and event, and the two measures, count and charge, where charge is the fare that a spectator pays when watching an event on a given date. Spectators may be students, adults, or seniors, with each category having its own charge rate.

a) Draw a star schema diagram for the data warehouse.

b) Starting with the base cuboid [date, spectator, location, game], what specific OLAP operations (e.g., roll-up from location to country) should one perform in order to list the total charge paid by student spectators at GM Place in 2010?

c) Starting with the base cuboid [date, spectator, location, game], what specific OLAP operations (e.g., roll-up from location to country) should one perform in order to list the total number of spectators at all the Metallica concerts in Canada in 2012?

d) Modify your answer to (a) to turn it into a Snowflake Schema