Question
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
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 DESIG
Relationships for hotel_edited rooms room number room_type cleaning cleaning record cleaning date room_number employid notes cleaning count reservation reserve_number reserve date reserve days rlast name rfirst_name Hilton_ number room_number reserve count reserveamount hilton honors Hilton_number Hilton_last name Hilton_first name Member type employee employid efirstname elastname 0 Relationships for hotel_edited rooms room number room_type cleaning cleaning record cleaning date room_number employid notes cleaning count reservation reserve_number reserve date reserve days rlast name rfirst_name Hilton_ number room_number reserve count reserveamount hilton honors Hilton_number Hilton_last name Hilton_first name Member type employee employid efirstname elastname 0Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started