Objective(s): Using an existing, normalized, transaction database, design a data warehouse. The data warehouse should be designed using a star-schema, de-normalized structure. The data warehouse design should also adhere to the best practices discussed in Chapter 3 of your textbook.

Methodology: You will be given a small (5 tables), normalized transaction database. Using the guidelines in Chapter 3 of your textbook for designing data warehouses, you will create a de-normalized schema for all fields. You must decide what tables should exist in the resulting data warehouse, how those tables will be related, and what fields will be contained in each table. Your design should also take into consideration the reporting and analysis that would ultimately be performed against the data warehouse. (Hint: You may want to begin with possible reporting requirements).

Deliverable(s): You will submit a final design for your data warehouse in an electronic document. The data warehouse design can be created using MS-Word, MS-PowerPoint, or MS-Visio. You are ONLY responsible for the DESIGN LAYOUT of the data warehouse: You are NOT required to build a functioning data warehouse in a DBMS (e.g., MS-Access, Oracle, etc.).

rooms room_number type cleaning cleaning_date room_number employid notes cleaningcount reservation reserve date reserve_days name rfirst_name ber room_number reserve_count reserve amount hilton honors Hilton_number Hilton_last name Hilton_first name Member type employee ployid me stname