. A pharmaceutical retail store manages its current sales, procurement and materials availability at the store through Excel sheets. Owing to the increase in the number of branches in the city, the store manager is now finding this process of data maintenance tedious. She is now banking on the multidimensional model to manage its store operations.

She identifies the questions that need to be answered for its store operations:

Sales by medicine and store location: How many medicines are to be ordered at the end of each month?

Frequency of sales by time dimension: Identify when to re-order.

The retail store manager therefore identifies the following dimensions: Medicines, Suppliers, Order, Store Location, and Time. The fact table contains the sales information for each day. Design a star type schema to represent this data mart. Identify the attributes and hierarchies (if any) for each dimension and measure to be included in the fact table.