Pennsylvania, Arizona, Florida, and New York. They have a central
database to store and track guest reservations. In 2008, they put
cafes in many of their hotels, called “Café in the Hotel.” They
have an order-tracking system that relays customer orders from the
wait staff to the kitchen. TU Hotels would like to use the data
they have collected to better understand the performance of their
hotels and cafes. They also have access to a database from the
online review site, “HotelComplainer.com.” Your task is to design
two-dimensional data marts using data from those three databases.
You will plan the star schema for each data mart by choosing the
dimensions, facts, and attributes from the data contained in those
databases. The relational schemas of those databases are at the end
of these instructions. Questions to be Addressed by Each Data Mart
Note: You will not actually come up with answers to the questions
in the table since you have no data. You will just be designing the
star schemas that can address these questions about the business.
The questions to be addressed by each data mart are listed in the
following table. You should include only the data fields you need
in each data mart, but the data marts can contain some of the same
data (i.e., the same fields can appear in both data marts). To
complete the assignment, perform the following steps: Identify the
main business event for each data mart. This will be the fact. Ask
yourself, “What is the basic business event that generates the
performance metric (revenue)?” Identify the attributes associated
with the fact. Ask yourself, “How is the business event quantified
(measured)?” Identify the dimensions and their attributes. Ask
yourself, “What data characterizes the various aspects of that
business event?” Either sketch the star schema or make a list of
the dimensions and the fact and their attributes. Finally, write a
brief, but detailed, explanation of your developed model.
- The Tu Hotel Chain Is A Small Chain With Properties Throughout Pennsylvania Arizona Florida And New York They Have A 1 (25.73 KiB) Viewed 23 times
- The Tu Hotel Chain Is A Small Chain With Properties Throughout Pennsylvania Arizona Florida And New York They Have A 2 (36.15 KiB) Viewed 23 times
Data Mart 1: Hotel Performance Data Mart 2: Restaurant Performance During which month are the most rooms rented? Identify the "off-season" (if any) for our hotels in Arizona, Florida, Which hotel restaurant generates the most revenue? Pennsylvania, and New York • Which hotel generates the most (non-restaurant) revenue? Do the best-rated hotels generate more restaurant revenue? What is the most frequently ordered item in the Philadelphia • What is the average length of stay in hotels with 4.5 or more stars? . Do smokers stay longer than non-smokers? metropolitan area? • For a given hotel, how many customers come from out of state?
Hotel Reservation Database Countries Countrycode Country.currency Country_name Hotel Amenities Lookup Characteristic Characteristic_description Hotels Hoteld Country code Hotel name Hotel_address Hoteloty Hotel_pcode Hotel rooms Room number Hotellid Room type Room floor Hotel Amenities Characteristica Hotel 4 Room Bookinys Booking Room type_code Hotel id Checkin_date Number of days Room_count Guest Booking Booking.id Guest number Room types Hoc type code Room standard_foto Room description Smoking Guests Guest number Guestfirstname Guest fastname Guest_address Guestety Guest code Guest email Hotel Complainer Ratings Database (totally external company) Café in the Hotel Database same company but database is not connected to the hotel) Rating Ratin. Hotel Id Detay Starting Hotels Hotel Countrycode Hotel name Hotel address Hotely Hotel pode Customer Customer ruber Customer_name Customer address Customer city Customer ripeode Order Order number Customer_number Hond Food amid Onder date Order_time Table_umber Hotel Rating Ratin Customer we_ofroting Customer atomet er Customer_name Customer address Customer city Customer_icode Customer Foodium Order number Food Jum_id Order date Order_time Hotels Hotel Country_code Hotel name Hotel_address Hotel_city Hotel