ACIS 5524 Assignment One (detailed and complete solutions)

1) The Key Requirements for the Hokie Resorts Hotel DB problem is that Hokie resorts has rapidly expanded, and they require a new support system to better track rooms, facilities, which serve multiple needs of their customer Requirement 1: Tracking Hotel Data (Buildings, Wings, Floors, Rooms) The Staff requires the ability to track data on Resorts including Building information, wing information, floor information, and lastly room information. This is pertinent to the reservation process and ensuring that customers are appropriately assigned to rooms per the reservation details. The Staff will also need to track data such as Room availability, Room Type, room charges, so that the customer is aware of such availability and associated room costs. Noting the varying room types will allow the staff to more effectively assign rooms based on their availability and configuration to support a given room type requested. Requirement 2: Maintain Reservation details (Customer Name, Billing Party Name, Reservation request details) The staff will need to maintain specific reservation details as to ensure that guests are given the appropriate room configuration based on their reservation details. Identifying customer name and billing party (if they differ) will allow the hotel the convenience on generating multiple invoices with the correct charges to the correct individual responsible. Reservation details are also important since room assignments are not made instantly upon creating the reservation. This provides the flexibility for the hotel to assign specific rooms as the reservation arrival date draws closer. Requirement 3: Provide the ability to generate a transaction list Hotel Staff will require the ability to generate a list of charges associated to the reservation. As noted above in reservation requirements, Billing party is identified, which allows the flexibility to charging the responsible party. This allows the invoice to be split between multiple individuals as necessary. Requirement 4: Track Event details and customer attendance As events are a key source of revenue associated to reservations, the staff would like to maintain and record data on events held at their resort locations. Key data the staff should focus on are Event Date