0
7.0kviews
Consider 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 data warehouse (clearly mention the Fact table(s), Dimension table(s), their attributes and measures).

1 Answer
2
1.0kviews

enter image description here

Please log in to add an answer.