Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hotel Management System: This project is concerned with developing a flexible, open-ended design for hotel management information system. Our Hotel Management System consists of two

Hotel Management System:

This project is concerned with developing a flexible, open-ended design for hotel management information system. Our Hotel Management System consists of two users:

1. Customer

a. Individual Customer

b. Company Customer

2. Staff

a. Manager

b. Other Employees

Customers can avail various services provided by the hotel like room reservation, restaurant, sauna, pool, casino etc. The system keeps a record of the customer details and previous visits of current and past customers so that privileges and points can be awarded based on their history. To keep the system history database to acceptable levels of data, excessive records are automatically purged at regular intervals. A Customers history consists of his/her previous visits, only one of which can be active (not completed) at any point in time. If no visits are active, then a new visit instance need to be created that can contain the various services that the customer need to avail during a new visit. If a visit instance is active, then any services availed are considered as part of that visit. Each visit is a composition of services that the customer uses. Any particular service usage consists of a single resource (e.g. Room No 110) that belongs to a particular service (e.g. Room Service). When a customer requests a resource, the system checks for that availability of the resource and adds that resource to the list of availed services during that visit. At the end of the visit, when all the service usages are finished, system automatically calculates the cost of the visit and also any points that need to be awarded based on this visit is computed as well. The customer has provision to redeem any in-house points that the customer has been awarded.

Manager(s) is (are) concerned with the overall functioning of the system. He/she has the provision to add new services or resources for any particular service. The system keeps track of the expenditure incurred by the various services which can be viewed by the manager. The managers decision making can be assisted based on the various services usage, total expenditure, total income etc., all of which the system automatically keep track of.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions