Design and Implementation of Hotel Management System

Analysis of the design and implementation of the hotel management system. Computer systems exist used to innovate traditional hotel competition methods and management methods, continuously expand hotel sales, reduce management costs, and improve guest satisfaction. Through the overall architecture of the system functions and also the design of corresponding functional modules, a hotel management system based on the B/S architecture realize.

Here are the articles to explain, Analysis of Design and Implementation of Hotel Management System

The system consists of functional modules such as room reservation, check-in reception, guest checkout, report management, and system settings, and realizes the use of computer systems and networks to manage hotel guests, guest rooms, and related equipment information. The system functions are relatively rich and detailed, and also the applied technology is relatively novel, which is of reference value for the design and development of similar hotel management systems.

Keywords:

• Hotel management system;
• Hotel database;
• The occupancy rate
• Hotel management;
• Also, the Hotel system;

The application of computers in hotel management has existed extended to various departments. And hotel management systems have become an important content of modern hotel management. Using a computer system to manage the affairs of the hotel, not only solves the disadvantages of manual management but also saves manpower and material resources.

The introduction of computer technology and network technology in hotel management to improve hotel occupancy has become one of the important links in the development of the hotel industry. At present, most hotel management systems adopt a C/S architecture. Each terminal must install a client. Also, Different versions need to develop for different operating systems. Once the operating system upgrades, follow-up technical support needs to provide.

This article design and implements a hotel management system based on the B/S architecture. The application of this system can effectively manage hotel customer information, reduce complex manual labor, save hotel operating costs, and increase hotel visibility through the Internet, thereby improving hotel market competitiveness. The system uses the guest to book a room and then check in at the hotel or check-in in a non-reservation form.

There are many booking methods available. The hotel administrator is responsible for entering the basic information of the guests, including the guest reservation form and the check-in form. Certain discounts implement for hotel regulars or guests with more rooms to increase the hotel’s occupancy rate.

System architecture

The system is based on the B/S architecture, uses a MySQL database to store data, and uses a Java development environment to realize client and server functions. The main functions include room reservation, check-in reception, guest checkout, report management, and system settings:

The room reservation function enables guests to book a room, select the reservation method, pay for the room in advance or pay again at check-in, provide the basic information of the guests, and complete the reservation after confirmation. Due to the variety of booking methods, the room payment does not limit to payment at the time of booking. If you book more rooms, you can specify a discount rate based on the standard room rate, which can increase the hotel’s return rate.

If the guest has already booked a room at the time of check-in reception, retrieve the relevant guest information data in the database, read the ID information, and you can check in. For registration in the form of non-reservation, the administrator needs to manually enter the basic information of the guest and check in separately. The design of the two check-in methods avoids the administrator from entering the same guest information multiple times.

The guest’s checkout completes the check-in and checkout by paying the room payment. At the time of individual checkout, specify the number of days and room rate to calculate the pre-payment to complete the single checkout, and the payment that has not yet stood completed will pay when leaving the store. Payment, indicating that the guest has completed the checkout.

More things;

Report management realizes the query summary of the main reports, constructs the query conditions of the reports, and retrieves the corresponding data to summarize the contents of the hotel reports. The report includes a booking report, reception report, and checkout report, which can comprehensively reflect the hotel’s operating income and expenditure status within a certain period, evaluate and evaluate the income and expenditure management of various links, and become an important basis for the hotel to prepare costs and profits, various expense plans, and designated room rates.

The system settings mainly configure the basic parameters and system parameters to realize the user’s addition, deletion, modification, and check operations. The system parameters are responsible for maintaining the basic situation of the hotel, such as the hotel name, address, etc., and setting up the guest account and booking account. The basic parameters cover room settings, building area settings, floor settings, etc. User settings In addition to basic operations, corresponding operation permissions can see.

System module design

To design effective functional modules, functional independence is a sign of module growth, that is, the existence of functional independence will lead to a good design of the system. Because of this, the basic functional modules of the system designed are for room reservation, check-in reception, guest checkout, report management, and system settings.

Room reservation

The room reservation type consists of individual reservations, group reservations, and meeting reservations. Guests make reservations by phone, fax, face-to-face, etc. There are many forms of reservations. Also, Guests are not necessarily in the store. Choose booking methods such as individual guests, teams, or meetings. It is suitable for single or multiple people to book in groups. Pay in advance or pay again when you check-in.

According to the regulations of the hotel industry, reservations can be classified as guaranteed reservations and non-guaranteed reservations. They can also call formal reservations and informal reservations. The official reservation must ensure the reservation of the guest, otherwise, compensation will require. Informal reservations are subject to availability, and there is no definite loss for breach of contract. The booking operation covers the reservation has stood accepted, arrived, not arrived, and canceled.

You can check the corresponding guest records. The administrator enters the guest reservation form. There are many fields to fill in the reservation form. But the name of the guest, the number of people booked, the number of rooms. And the arrival and departure dates must fill in. Also, The retention period is the expiration date of the validity period of the order. And the reservation can exist canceled after it expires.

After the entry complete

Obtain the unoccupied empty rooms for the room arrangement. The room arrangement can be a manual room arrangement or a smart room arrangement. The smart room arrangement selects the corresponding room in order from the lower floor to the upper floor. The current room arrangement situation of the reservation form can view through the reservation arrangement chart.

Reservation modification can modify the reservation form of the already booked guest, and the room arrangement information can also modify. If the reservation has stood processed. If there is an advance payment, it must refund to the guest. And then re-enter the advance payment in the accounting processing. The two operations of positioning and filtering condition setting are suitable for the case of more bookings. If no record is the same as the input condition. Then locate the record that is similar to the condition. Also, the filtering setting will keep the records that meet the conditions.

Check-in reception

The administrator performs guest check-in reception by filling in the individual guest registration form, group registration form, or meeting registration form. During the entry process, the blacklist, historical guests, etc. will jump out in time. After completion, enter the room card and deposit the relevant information into the room card. The guest selects the room type and whether multiple people are staying.

The administrator enters the arrival date and departure date calculates the number of days of stay and selects the room to register in the list of available rooms. You can select multiple rooms at a time. If you do not book in advance, enter the guest information such as name, ID number, room type, home address, original room rate, discount rate, etc.,

The reservation can access the guest information data stored in the database. And multiple rooms can check in at the same time to avoid entering the same guest information multiple times. Team registration is different from individual guest registration. If you book a stay, select the group name, otherwise, you need to enter the group name in advance, etc. If there is no relevant member information, you must enter it manually.

Guests checkout

The checkout can be check-out or single-item check-out. Group check-out is specially set up for groups, temporary check-out, and accounting processing. And customer receivable management stand set up for special guests. If a guest needs to leave the hotel to check out, enter the room number.

At this time, you can check the guest’s account status at the hotel in the main payment account number, sub-payment account number, prepayment, and consumption account. The payment method can be cash, registered account, credit card or check, etc., and the guest’s checkout will complete after confirmation. The system prompts that the check-out is complete, indicating that the guest has completed the check-out.

Early checkout means pre-payment of the room fee, and the account of a certain guest settle in advance. By entering the guest’s room number, the guest’s consumption items appear, fill in the number of days in advance. Calculate the sum of the pre-payment of the room fee, and complete the early checkout for the guest. A single settlement is a single settlement of the consumption accounts of a certain guest.

For example

A single settlement of the item can make for the consumption of meals. Group checkout is a settlement operation for teams and meetings. Only the accounts consumed by the group or meeting settle. After the checkout, the group or meeting members will convert to individual customers. Members can leave the store without checkout or checkout when they leave the store. The former must confirm by the person in charge of the group.

The temporary checkout function handles the situation where the guest leaves the store. But cannot check out immediately, temporarily hangs up the account, and waits for settlement in the future. Accounts at other cashiers must be settled on the same day. If there are special circumstances, it will be posted to the temporary account when the checkout is not possible on the same day. The historical account is set in the system management.

When the tenant does not arrive at the cashier to check out but comes to the front desk to check out, the temporary checkout is used at this time. Accounting processing means making up, reconciling, or prepayment of the guests’ accounts, and in-house inquiries to inquire about the guests staying in the hotel, including individual guests, teams, meetings, etc.,

Enter the query conditions to summarize the guest’s stay in the hotel. Blacklist queries are operations to query, add, modify, or delete persons wanted by the Ministry of Public Security. Such as criminals, spies, or public enemies of the state. When the input guest’s name, ID, etc. matches the person on the blacklist, the system will prompt that a person is a suspicious person.

Report management

Report management mainly includes booking reports, reception reports,s and checkout report management. Select the expected arrival guest list, the default is the expected arrival guest list on the same day. And the expected arrival guest situation can be found by modifying the date. The reception report covers the arrival guest table, the in-store guest table, and the departure guest table. The settlement report can be a payment schedule. A replenishment or reconciliation detailed report, a front desk settlement report, and an advance payment report. Guest sub-account schedule, a guest arrears report, a team arrears report, or a unit’s pending arrears report.

System settings

In the system parameter function, you can set the name of the main server. The basic parameters of the hotel, and enter the starting account number of the guest. And the starting account number of the reservation, and select the permissions of the functional modules. Such as catering reservations, system management, material management, and reporting system.

The basic parameter functions mainly include building area settings, floor settings, room type settings, guest room settings, and department settings. User information consists of the operator’s employee number, name, and department to which it belongs, etc. And can give the operator module permissions such as booking, reception, checkout, and catering.

System implementation

The system implementation of the hotel management system. It is based on the three-layer MVC architecture. The database access layer is responsible for retrieving and storing entity object data, sending and receiving data transmitted by the controller layer, and the view layer interacts with the controller layer to display page data or return processing results to the controller layer. The entity table of the database mainly includes the guest room table, the guest room reservation table, the guest registration form, the hotel parameter table, and the user table.

The guest room table is responsible for maintaining hotel room data, including room number, room type, room status, building area and floor where the room is located, room rate, etc. The hotel administrator enters the room data through the operating system setting function. The room type can be a single room, a standard room, a business suit, or an executive suite, and the room status can be set to be cleaned, by individual guests, meetings, control rooms, or teams.

The guest room reservation table consists of the main reservation table and the auxiliary table. The main table stores the reservation number, basic guest information, arrival date, departure date, reservation room type and room rate, etc. Auxiliary tables such as the room arrangement table record the room number, room type, arrival date, departure date, and other data. Guests provide their basic information when booking a room, select the room type and determine the arrival date and departure date. And store the guest information and reservation information in the room reservation-related form.

Registration form filling

The guest registration form covers the main registration form, the team registration form, and the registered room rate form. The main registration form is responsible for storing the basic information of the guest, the date of arrival, the estimated date of departure, the registration category, the registrar, etc. The team registration form maintains the team information, the number of registered guests, the total number of rooms, the type of discount, the type of customer source, etc.,

The registration room rate form records the registration number, room type, number of rooms, room rate, and discount rate. Guests provide documents and other information when checking in to the hotel. If you have booked a room before. You can obtain the data in the reservation form to avoid entering the same guest’s information multiple times. Otherwise, you must manually enter the relevant data and store the registration information in the guest registration form.

The hotel parameter table is used to store the main server name, hotel name, starting guest account number, booking account number and cashier account number, etc. The user table realizes the storage of user information and operating permissions such as tenants and operators. The administrator is responsible for maintaining the data records in the hotel parameter table and user table through the system setting function.

Ending mentions

The hotel management system is an important content of hotel management. This article expounds on the functional architecture and module design of the hotel management system. The system is relatively rich in functions and the applied technology is relatively novel. Which is of reference value for the design and development of similar hotel management systems. Adopting the hotel management system designed and implemented in this article can not only improve the hotel occupancy rate. But also reduce management costs and lay a solid foundation for the further development of the hotel.