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...

Extracted text: 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 measures to be included in fact table. Star Schema for the pharmaceutical retail store data mart: