The senior management of a leading global hotel chain are looking for a Data-Warehousing solution to
support strategic decision making to optimally market their business. You have been hired to develop the
DWH solution for your client. The hotel management would like to study the occupancy patterns in their
hotels over time (days, weeks etc), locations, travel agents, customers, room types, rate plans(packages), etc.
Furthermore, they would also like to have ready access to the rooms that are occupied or vacant on a given
date. Create an information package diagram for hotel stays, identifying the dimensions, attributes, and facts