Data warehouse
Question1 The Best WesternHotels and Resorts is an international hotel chain company that operates about 4,200 hotels and motels around the world. As the company's business has encountered a huge growth in the past two years, the head quarter office aims to analyze the performance of the company comparing to some competitors. In particular, they need to track the Occupancy Level in each of their hotels. This can be achieved through analyzing the number of available rooms, unavailable rooms, number of occupants, and revenue. The business factors that the analysts team will consider to analyze the Occupancy Level along are: Time, Hotel, Hotel Staff, Hotel Region, Room Type, Occupants/ Gusts a. Create a complete information package diagram for the information given in the schema b. Create a star schema for the information showing all dimension tables, fact table, attributes, and the relationships between the tables. Identify key attributes and relationship cardinalities c. Assume that the staf member named David Earley works in Best Western Hotel located in Cannes, France After having worked for ten years in Cannes, the hotel location has changed to Monaco City. What type of update is this? How would you update the Hotel Staff dimension table? Show the new dimension table and its attributes d. Assume that the head quarter office needs to know the total number of rooms for the Best Western Hotels in each region. What type of Additive Measure is used? Which metrics will used to calculate the result? Question1 The Best WesternHotels and Resorts is an international hotel chain company that operates about 4,200 hotels and motels around the world. As the company's business has encountered a huge growth in the past two years, the head quarter office aims to analyze the performance of the company comparing to some competitors. In particular, they need to track the Occupancy Level in each of their hotels. This can be achieved through analyzing the number of available rooms, unavailable rooms, number of occupants, and revenue. The business factors that the analysts team will consider to analyze the Occupancy Level along are: Time, Hotel, Hotel Staff, Hotel Region, Room Type, Occupants/ Gusts a. Create a complete information package diagram for the information given in the schema b. Create a star schema for the information showing all dimension tables, fact table, attributes, and the relationships between the tables. Identify key attributes and relationship cardinalities c. Assume that the staf member named David Earley works in Best Western Hotel located in Cannes, France After having worked for ten years in Cannes, the hotel location has changed to Monaco City. What type of update is this? How would you update the Hotel Staff dimension table? Show the new dimension table and its attributes d. Assume that the head quarter office needs to know the total number of rooms for the Best Western Hotels in each region. What type of Additive Measure is used? Which metrics will used to calculate the result
