Suppose a company wants to build a data warehouse to analyze sales of its cars. The data warehouse consists of the following four dimensions: Autos, dealers, and the sales and count measures.

(a) Draw a snowflake schema for your data warehouse.

(b) What is the base cuboid?

(c) Assuming one level of concept hierarchy, what is the number of cuboids in this data warehouse?

(d) Starting the base cuboid, what specific OLAP operations should one perform to list the following:

a. The total sales of blue cars for each dealer.

b. The total number of green Honda cars sold by dealer "MIke's Cars"