You work for a large corporation that has just purchased 2 hotel and resort corporations each consisting of over 100 hotels. each corporation operates a custom database. you are provided the data dictionary and er diagrams for the two operational databases. management would like you to design a data warehouse that allows them to achieve the most competitive advantage possible.

(note: the databases you will evaluate come from student groups in another class responding to the hokie resort problem. this problem also is provided for your review.)

to achieve this you decide to do the following:

review the hokie resort situation description and the er diagrams for the two operational databases.

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. (10 points)

design a data warehouse star or snowflake schema that is sufficient for addressing these questions. submit an er model and the oracle ddl* that implements your data warehouse schema (note: you do not have to implement the schema in a dbms). (15 points)