Consider the following dimensions for a Hypermarket chain: Product, store, Time and Promotion. With respect to this business scenario, answer the following questions. Clearly state any reasonable assumptions you make. Design a star schema. Whether the star schema can be converted to snowflake schema? Justify your answer and draw snowflake schema for the datawarehouse (clearly mention the Fact Table (s), Dimension table(s), their attributes and measures).