Hotel Management System
Hotel Management System

Introduction of Online Hotel Management System:

Are you looking for an online hotel management system project? We are here to help you. You can contact us. The project Online Hotel Management System is a web-based application that allows the Hotel Manager & Owner to handle all hotel activities online easily and safely. Using Interactive GUI anyone can easily learn to use the complete system.

Using this Hotel Manager doesn’t have to sit and manage the entire activities on paper. And at the same time Owner of the Hotel will feel comfortable keeping a check on the hotel easily from anywhere around the world. This System will give them power and flexibility to manage the entire system from a single online portal.

Hotel Management System provides room booking, staff management, and bill generation features. The system will be so simple and attractive which will make the customer comfortable to use and choose their ideal room. The system allows the Owner to check the Progress of the hotel from interactive Graphs and he will be notified of each new change made in System.

The system allows the manager to keep track of available rooms in the system and even maintain staff details like their hours worked and salary. Customers can view and book an available room online and the system will automatically generate the bill according to the number of days the type of room is booked.

You can check these posts:

Modules of Online Hotel Management System:

There are several modules required to complete this system. Here we are discussing the main modules or core modules of the system.

Owner Profile:

In the Owner profile, he has full access to the system. The owner can view all the details in a graphical way and he has the authority to change the Cost of Room, Room Availability, Service Details, and much more. He can also check the details of the receptionist and staff member currently working at that Hotel.

He will get the notification of all the changes made by the Manager in the system. He will also have special permission to revert those changes if needed. He can also check the transactions made through the day and thought the month and an algorithm will check the progress the Hotel is making.

Manager Profile:

Manager profile can have partial access to the System. The manager can view the availability and can change the cost of the room and other service details. He will also have a special interface where he can manage the staff of the hotel. He can add new people and he can also remove anyone from the system. And at the same time Owner will receive the notification of these changes.

Customer Profile:

In the Customer profile, people can check the availability of rooms and they can also book a room according to their budget and need. Customer profile contains their name, Contact details, address, and other necessary details, etc. They need to sign-up for booking the hotel, which will make them as well as the manager of the hotel easily interact with each other.

They can pay the amount Online and if they need to do payment Offline, they must give some advance amount to confirm their room.

Receptionist Profile:

In the Receptionist Profile, who so ever is the Receptionist must log in and then he can book the hotel for the customer and this will serve the customer as offline mode. When he will log-in his attendance will be taken and it will be easy for the Manager and Owner to monitor them. Here they will also get a notification of booked room so that they can beforehand maintain the room.

Staff Profile:

In the staff profile, there will be complete details of each staff of the hotel like their personal details and their post at the hotel. They can easily give their attendance to the receptionist and that attendance details will be visible in Real-time to Manager.

Booking:

The customer can easily search their Room from the various option available. This all will be so user-friendly so that Customer will not find any trouble in the booking room. Once the room is searched and the customer finds his choice room then this module helps the customer to book the room by following the rules of the Hotel like Check-in and check-out time of the Hotel, Limit of people per room, etc.

If everything is done properly, he will be asked to pay partial or complete money. And then he will be forwarded to Payment Gateway. Where he can easily pay Online.

Payment Details:

After filling in the booking details clients need to pay the money using different options available like cash/net banking/ATM card. The payment portal would use a payment gateway to clear payment. Once payment will clear receipt of payment will be generated automatically and this receipt will be sent to the manager and the Receptionist will get the notification to make the room ready before they arrive.

Add/Update/Delete Hotel Members/Booking Details:

The owner and Manager can easily add, update, or delete the Staff details. If the customer does not reach the hotel within 3hr of check-in time and if he does not give any prior details of this arrival then the receptionist will have complete authority to remove his booking and allow another customer that room if needed.

User Authentication According to His/her Role:

This portal will take care of every profile in our system. No user will be allowed to use our system without a valid ID. Every profile must authenticate using system procedure. This would ensure the security of our system.

System Design of Online Hotel Management System:

This complete System run on the simple Interface was there are only three users i.e. Owner, Manager, and Customers.

The case of Customers of Online Hotel Management System:

The customer can view the Availability of a Room in the Hotel. If he wishes to book, he has to sign-up by providing his contact details, and then a user ID will be generated using this he can securely enter the System, and then he can book and Pay Online with full security.

He can also change his check-in time and check-out time if possible. He can also cancel the booking if he doesn’t wish to visit.

The Case of Receptionist of Online Hotel Management System:

The receptionist will check all the details of Customer check-in and check-out date and time and settles any pending payments. And He will have authority to allow Room number to Customer on their arrival. He will take care of all customer needs and their comfort.

The Case of Owner/manager of Online Hotel Management System:

The owner, as well as the manager, has almost the same Authority. Both can see all the details of the hotel and can Change. The manager can change details but the Owner will receive the notification of any changes made by him. So that it will be easy for the Owner to keep track of his hotel even if he is far away.

This all will take place securely since both Manager and Owner will have separate IDs and whatever they will do all will be fully secure in this system. The owner, as well as the manager, has almost the same Authority. Both can see all the details of the hotel and can Change. The manager can change details but the Owner will receive the notification of any changes made by him.

So that it will be easy for the Owner to keep track of his hotel even if he is far away. This all will take place securely since both Manager and Owner will have separate IDs and whatever they will do all will be fully secure in this system.

User Interface (UI) of Online Hotel Management System:

The user interface is a very important part of the system. This helps every member of the system to interact with each detail properly. As we have shown several use cases in this system. We have developed these interfaces to interact with the system.

Login Page:

Owner or Manager need to log in using login id and password.

Customer Page:

Can view their details as well as Booking details.

Receptionist Page:

He can Offline Book the available room at the hotel.

Payment Page:

This interface helps in paying the money via several modes.

Er-Diagram of Online Hotel Management System

There are mainly Seven Entities Owner, Manager, Employee, client, hotel, Payment, book. These five entities would manage the whole system. There are mainly Seven Entities Owner, Manager, Employee, client, hotel, Payment, book. These five entities would manage the whole system.

Owner:

The owner is a superuser of the system. The owner is just like the admin. The owner has all right to view and modify the data in the system.

The owner has the following attributes:

Owner ID:

This is a numeric 14 digits number that is unique to every admin. The owner ID is the primary key to the admin table in the database.

Name:

This attribute would hold the name of the owner. The name is a varchar type variable that holds the data length up to 250 characters.

Email:

This is an essential attribute of the table. Every owner must have a working email id to keep in contact with employees. This field has validation only email formatted values will be stored.

Contact.:

This is multi valued attributes which mean every owner can have more the one mobile number in database.

Address:

This attribute would hold the address of the owner. Each employee must provide the address.

Manager:

The manager is a secondary user of the system. The manager can view hotel details, manage employees, booking, solve client’s problems.

The manager has the following attributes:

Manager ID:

This is a numeric 14 digits number that is unique to every Manager. Manager ID is the primary key to the Manager table in the database.

Name:

This attribute would hold the name of the manager. The name is a varchar type variable that holds the data length up to 50 characters.

Email:

This is an essential attribute of the table. Every manager must have a working email id to keep in contact with employees. This field has validation only email formatted values will be stored.

Contact.:

This is multi valued attributes which mean every manager can have more the one mobile number in database.

Address:

This attribute would hold the address of the admin. Each employee must provide the address. Admin address is verified via the Human resource team.

Employee:

The employee is another user of the system. An employee can view hotel details, verify the online booking room availability for clients.

The employee has the following attributes:

Emp ID:

This is a numeric 14 digits number that is unique to every Employee. Emp ID is the primary key to the Employee table in the database.

Name:

This attribute would hold the name of Employee. The name is a varchar type variable that holds the data length up to 50 characters.

Email:

This is an essential attribute of the table. Every employee must have a working email id to keep in contact with employees. This field has validation only email formatted values will be stored.

Contact.:

This is multi valued attributes which mean every employee can have more the one mobile number in database.

Address:

This attribute would hold the address of the employee. Each employee must provide the address.

Client:

The client is the basic end-user of our system most of the business is done through them. Clients would book the desired hotel room. The client would provide feedback.

The client has the following attributes:

Client ID:

This is a numeric 14 digits number that is unique to every Client. ClientID is the primary key to the client table in the database.

Name:

This attribute would hold the name of clients. The name is a varchar type variable that holds the data length up to 50 characters.

Email.:

This is an essential attribute of the table. Every client must have a working email id. This field has validation only email formatted values will be stored.

Address:

This attribute would hold the address of clients. The address of clients would help us to connect with them and visit the location. This would provide better services.

Hotel:

Every hotel registered with the system has the information in this entity. Hotel is the main concern of system.

Hotel ID:

This is a numeric 14 digits number that is unique to every Hotel. Hotel ID is the primary key to the case table in the database. Each hotel is uniquely identified using this id.

Name:

For customer point of view, every hotel does have its name. The name is very important.

No Of Rooms:

Every hotel has many rooms. To make it easy for the customer. And check availability no. of rooms should be in the database.

Address:

This attribute would hold the address of the hotel. Address of Hotel would help the client to find it easy and visit the location. This would provide better services.

Book:

Before going to book any room. The client should check the availability. If the desired room is available. They can book it.

Book ID:

This is a numeric 14 digits number that is unique to every Booking. Book ID is the primary key to the case table in the database. Each Payment is uniquely identified using this id.

Room NO:

With reference to hotel booking must have room no.

Date:

This would hold the date of the transaction.

Payment:

Payment Entity stores the data about payment. Every payment data is here. Any conflict can be resolved by looking at this.

Payment ID:

This is a numeric 14 digits number that is unique to every Payment. Payment ID is the primary key to the payment table in the database. Each Payment is uniquely identified using this id.

Booking ID:

This is a reference to a booking. This would help the admin to find this payment is against booking.

Date:

This would hold the date of the transaction.

Transaction No.:

The transaction number is referencing no given by the bank.

Status:

Status of every transaction either it would be pending or confirm is being updated in this field.

Design Data Dictionary for Er-Diagram of Online Hotel Management System:

The data dictionary is useful in case of development.

Table Name: Owner Master

Primary Key: Owner ID

Description: To store the details of admin

Serial No.FieldsDatatypeDescription
1.Owner IDIntegerPrimary key
2.Namevarchar 
3.Email IDvarchar 
4.Contact.IntegerMultiple contacts can exist for a single admin
5.Addressvarchar 

Table Name: Manager Master

Primary Key: Manager ID

Description: To store the details of General Manager

Serial No.FieldsDatatypeDescription
1.Manager IDIntegerPrimary key
2.Namevarchar 
3.Emailvarchar 
4.Contact.IntegerMultiple contacts can exist for a single admin
5.Addressvarchar 

Table Name: Employee Master

Primary Key: Employee ID

Description: To store the details of Employee Details

Serial No.FieldsDatatypeDescription
1.Employee IDIntegerPrimary key
2.Namevarchar 
3.Emailvarchar 
4.Contact.IntegerMultiple contacts can exist for a single admin
5.Addressvarchar 

Table Name: Client Master

Primary Key: Client ID

Description: To store the details of Clients

Serial No.FieldsDatatypeDescription
1.Client IDIntegerPrimary key
2.Namevarchar 
3.EmailvarcharMultiple contacts can exist for single client
4.Addressvarchar 

Table Name: Hotel Master

Primary Key: Hotel ID

Description: To store the details of Property

Serial No.FieldsDatatypeDescription
1.Hotel IDInteger                     Primary key
2.Hotel Namevarchar 
3.Addressvarchar 
4.Number of roomsInteger 

 Table Name: Book Master

Primary Key: Book ID

Description: To store the details of Payment

Serial No.FieldsDatatypeDescription
1.Book IDInteger                     Primary key
2.Room No.Integer 
3.Datedate 

Table Name: Payment Master

Primary Key: Payment ID

Description: To store the details of Payment

Serial No.FieldsDatatypeDescription
1.Payment IDInteger                     Primary key
2.Book IDIntegerForeign key to Book Master
3.Datedate 
4.Transaction No.varchar 
5.Statusvarchar 

Hotel Management System Project

Conclusion of Online Hotel Management System:

Finally, in the Online hotel management system, we have developed a secure, user-friendly Hotel Management System. This System can take care of each member whether its Owner or Customer. This System will Help them to properly Manage their hotel and help in growth without creating any hassle.

This system is completely secure since every user is provided with a user ID and Password so there is no chance of any unauthorized access. Online Payment, Booking, and cancellation make it easier to use. So, using this system will help in reducing the labor and provide more facility for Customer to like Hotel and visit again and again.