Reference no: EM131309265

Data Warehouse

1. Review the submission Hokie Resort situation description to understand the problem domain(see Business Situation Description below)

2. Write the three most important questions that management must answer to achieve a competitive advantage in the hotel market.

3. Design a Data Warehouse Star or Snowflake schema that is sufficient for addressing these questions.

4. Analyze the ER diagram and data dictionary from both of the operational databases to determine if the two operational hotel databases have the data needed for your data warehouse.

5. Write the SQL necessary to extract and process the data from the two operational databases so that it will be suitable for your elements of your data warehouse.

6. Explain how users will query the data warehouse to easily determine the answer to the three most important questions (from step 1). Be sure to use language that the users of the system will understand.

7. Write the SQL that will be needed to answer the three most important questions using your data warehouse. This requires writing 3 SQL statements/procedures.

Attachment:- Project_Directions.rar