Design a Star schema for a large grocery chain. The business has 100 grocery stores spread over five states. Each of the stores has various products under the categories such as grocery, frozen foods, dairy, bakery etc. The products depending upon the category have a packaging type, price, shelf life, fat content, unit for measuring weight etc. The store also runs certain promotional schemes and offers discounts or combo packs for the above-mentioned products. The management of the store is interested in knowing the quantity of sales both in number and in rupees at different period of ear (year, quarter, month etc) in order to increase its profit and better serve the customer. The management also wants to know the net profit from sales, popularity of different products in different states, in different seasons and which type of promotion scheme is most popular.

Would you consider snowflaking this schema? Why or why not?

a. i) Briefly explain with examples the following concepts in context of a data warehouse

i. Fact Table

ii. Data Mart