28-11-2012, 01:32 PM
Hotel Reservation System: L&M Towers
Hotel Reservation System.pdf (Size: 125.51 KB / Downloads: 42)
Problem Statement/Requirements Definition
Hotels have been around for a very long time, using various methods of keeping records. Historically, hotels have kept paper records in filing cabinets. However, hotels are much larger now with many customers to keep track of with regard to types of accommodations, whether low budget, luxury, or somewhere in between, as well as smoking or non-smoking preferences. Keeping track of large customer bases and all their attendant details would require an inordinate space for file cabinets, not to mention the time employees would spend going back and forth to file cabinets looking up each client’s information! JADE is a large new hotel, and requires more sophisticated methods of tracking customers and their preferences, as well as all the details about each customer and the rooms themselves. JADE is a complex of two towers, offering many differing types of accommodations with the prospect of a large customer base. JADE has decided to implement a relational database for record-keeping.
The general requirements for a new customer are: in order for the customer to make a reservation they need a first and last name, valid address, credit card number, and phone number. They will be informed about the two towers we have, the different room types available, and the prices for each of the room types. Then the customer can make an informed decision in what they want. After the reservation is complete the hotel database will assign a customer ID number to the new customer. But as far as the customer is concerned they are simply given a confirmation number for their reservation, which they present upon arrival.