Hotel Reservation System

Only available on StudyMode
  • Download(s) : 888
  • Published : March 19, 2012
Open Document
Text Preview
Hotel Reservation System: L&M Towers

ade
2

Jill Jones Abe Miessler Archana Patel Dominique Ralph Erik Sisco Proposal Phase CSCI273 Project October 7, 2003

-0-

Table of Contents
List of Team Members & Initial Responsibilities ................................... 1 Problem Statement/Requirements Definition .......................................... 2 - 3 Entity-Relationship Model ......................................................................... 4 Use Case Diagram ....................................................................................... 5 Narrative Description of Project Use Cases ............................................. 6 - 7

List of Team Members & Initial Responsibilities
Team Members: Dominique Ralph, Archana Patel, Erik Sisco, Jill Jones, Abe Miessler Team Leader: Dominique Ralph Division of Labor (Proposal): All: Mutual work on diagrams, concurrence on Background, Requirements, and Business Processes. Jill: Background, history Archana: Requirements Erik: What’s to be done, business processes Dominique: diagrams, putting it all together Abe: Joined group on October 2, 2003

-1-

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. If the customer is a returning guest and wants to make a reservation all their information is already in the database. Therefore, all they need to present is the arrival and departure dates and the room type they want. In return we give them the price and a confirmation number, which again they present upon arrival.

-2-

As the database development team, we will be creating a database which will have a three actor system. There will be the following actors: customer, employee, and administrator. Each will have a varied level of access to the details of the hotel and reservations made at the hotel. The customer will provide biographical information which will be entered in and alterable by any of the three actors. The main business process focused around the database will be creating

reservations for J.A.D.E. hotel. After the employee submits the customer’s preferences a query will be done to the database to find a suitable accommodation. As a secondary process we will allow modification of data states by the Administrator (i.e. change which floors are smoking/nonsmoking). The problem of slow paper filing systems will be solved with merely accessing the...
tracking img