Question5

OLAP: Suppose a market shopping data warehouse consists of four dimensions: customer, date, product, and store, and two measures: count and sales, where count stores number of transactions and sales stores total sales in dollar amount.

a. List tables (both fact table and dimension tables) in its star schema and make reasonable assumptions on higher levels of each dimension, for example, week, month, year for date.

Note: Write a table in the format: table_name(attribute1,attribute2, ...)

b. Starting with the base cuboid [customer, date, product, store], what specific OLAP operations (e.g., roll-up student to major) that one should perform in order to tabulate the sales of each cosmetic product in each month since January 2018?

c. If each dimension has 5 levels (excluding all), such as store-city-state-region-country, how many cuboids does this cube contain (including base and apex cuboids)?