2 Write the three most important questions that management must answer to achieve a competitive advantage in the hotel market. Submit the questions and a brief (1-2 pages) explanation/justification of why these are the most important questions. (5 points) 3 Design a Data Warehouse Star or Snowflake schema that is sufficient for addressing these questions. Submit an ER Model of your data warehouse Star or Snowflake schema. (10 points) See this example of a star schema from the Hokie Hospital problem: HospitalDWSchema.vsdx Example as pdf: Visio-HospitalDWSchemav2.pdf@ 4 Implement your Data Warehouse Star or Snowflake schema in MySQL or other DBMS. Submit the MySQL of other DDL that implements your data warehouse schema. (10 points) Hokie Resorts Business Situation Description: You work for a large corporation, Hokie Resort Hotels, that has just purchased 2 hotel and resort corporations each consisting of over 100 hotels. Management would like you to design a data warehouse that allows them to achieve the most competitive advantage possible from these acquisitions. The two corporate databases and data dictionaries for them are available under milestone 2. You should also review them to understand the problem situation. Hokie Resort Hotels has grown rapidly over the past several years with the acquisition of Club Med chain and several very high luxury hotels worldwide. They have been adding more rooms, more extension wings on buildings, and