Executive Summary
- Purpose:
- The Nova Hotel Management system has been designed by Whitestar Software with several ideas in mind.
Formost is a concern for timely response to hotel customers.
To serve this end we have designed the system to be easy to use and to have quick response to the user.
We have also designed several features into the system to ensure the smooth running of the system when in actual use. This includes such items as never deleting invoicing and employee information, mostly for security and legal reasons. We feel this system will meet and exceed the high standards placed upon us by yourselves.
- Customer Comments and Questions
- You, our customers, have raised several excellent questions and made several astute observations.
Most signifigantly you asked for several modifications to the query capabilities and had several questions regarding who had access to what information. Below, listed by table, is the level of security given to each user type, for a more detailed view of this information please see the document titled Response To Customer Questions.
- Customer Table: front desk and management
- Room: front desk and management
- Employee: management
- Room Services: room service, front desk and management
- Fees: managment
- Data Abstractions
- Our data abstractions are based on eight types of objects. They are: Employee, Guest, Invoice, Fee, Room Type, Credit Card, Security, and Room.
We also have the weak entity of Room Service, under which all the items that can be done to a room fall, this now includes wake up calls as well.
Below is a list and general description of the relationships designed for the above entities:
- signed In:
- Links a Guest to the Employee who signed them in, and to the Room they are staying in.
- signed Out:
- Links a Guest to the Employee who signed them out and the Room they signed out from.
- Booked By:
- Links a Guest to the Employee who booked then and their Room.
- In Room:
- Security For:
- Links an Employee to their Security level.
- Credit Card Of:
- Links a Guest to a Credit Card Type.
- Room Type Of:
- Links a Room to the Room Type it is, for example a single or double room.
- Charged To
- Links an invoice to a Guest.
- Billed For:
- Links a Invoice to a Room.
- Issued By:
- Links an Employee to an Invoice that they have issued.
- Fee Of:
- Links a Room Service to a Fee for that service.
- Dilivery By:
- Links a Room Service to the employee who delivered or performed it.
Modules Specs
- Moduality for this project has been broken into categories based upon the tpye of user.
As stated elsewhere the users can be broken down as managers, room service, front desk, and accounting.
The functionality of these general modules is further segmented based upon what data abstraction they manipulate. Detailed information such as who calls the functions, what the function calls, the order and description of its operation, and a text description of how the function should work are stored at this level.
Reports
- Reports are generated for each of the follwing activities:
- Room Service Billing
- Cleaning Schedule
- Missed Reservations
- Employee Information
- Guest Invoice
- Quarterly Report
All of these reports include the date of generation and all other items of importance dealing with the given activity. In trying to make the system as easy as possible to use only one type of report is generated for each of the items listed above. Please review the reports page and inform us of any missing items.