Design a data warehouse using star schema or snowflake schema that solves a specific business intelligence task that you come up with. Only one fact table is needed.

You will need to include:

1) a problem statement (i.e. what is the purpose this warehouse is serving)

2) an ER diagram describing the designed schema

3) the justification for your fact table and dimensions.

You can include all components in a word document. Some tasks you can consider: analyzing sales, analyzing hospitalized patients, analyzing student performances, etc.