This is our project about HOTEL MANAGEMENT SYSTEM to manage bookings, employees, rooms, service and hotels efficiently in order to provide best service. We have implemented this project using the concepts of database designing along with frontend using c# and MS Sql Server to make our program more efficient. We have provided few services such CRUD operations for all aspects where required. We have also tried to manage project security and integrity using various constraints and abstracting data.
Make sure that you have Microsoft Sql Server installed in your PC. Along with that I have already uploaded the query file which you just have to run to create database. Connect your application from Visual Studio Code with Microsoft Sql Server services of integrating database. You are now good to go!
Here's the logic behind our project. The design of our project is based on SAS applications where we provide Software as Service. Firstly, we are the super admins of this application and the hotel owners can get our application on subscription based model. We will be registering the hotels in database and authenticating them to use this application. The purpose is to build this in a way that this reduces the manual and paper work for managing hotels, guest’s and employee’s data. Moreover, we have also added to functionality to provide hotel reports in order to maintain the record of bookings and payments. We have provided full rights to user where he can add, update, search and delete information when required. Best database design is used in order to increase efficiency of managing data from various hotels. Application have following features: • Adding, updating, deleting and searching Hotels. • Generate hotel reports based of bookings. • Adding services. • Adding employees. (CRUD) • Adding guests (CRUD) • Maintaining payments of guests. • Maintaining revenue of hotel.
The motivation behind the idea is that now a days the world is getting digitalized so in order to remove all manual and paper work we have created system which would help us to manage data more accurately and efficiently. Moreover, this would give an ability to keep records of guests and employees which could be further used for analytics.
- When a hotel owners comes to register his hotel in database and avail subscription, we will add hotel details in the database and provide a username and password which must be change when the user login for the first time.
- Hotel owner (user) has a right to add employee, add services, add discounts and add rooms. He can also view details of bookings, guests and payments. Total revenue would be visible only for the owner.
- He can also add room type and departments in the system.
- Once a hotel owner adds employee, if he is from HR, Admin or IT department so it’s necessary to create account that would be auto generated.
- When employee login first time, he will change password and add security question along with answer. This would ensure the maximum security of the application.
- Registered employee can add guests, rooms, discount, services, payments and bookings. All have CRUD operations.
- Guest status can be changed to check-in and checkout.
- Employee can filter data according to check-in and checkout.
- Aggregate cost of stay duration and services used is automatically generated along with giving discount if applicable.
- On checking out of the guest, the amount is added to hotel gross revenue.
- The rooms have status of availability which would be marked as YES if it’s not booked and NO if it’s reserved.
- Room type can be set by employee and ceo along with the rates.
- Login user can reset there password if required
We faced most of the challenges in creating relationships among tables. We need to make sure that all the relationships created among tables are logical and follow the normalization rules. The most challenging part was creating the booking and the rooms table and its relationships with other respective tables. Another challenge was to learn and research about the designing framework to use for frontend and we ended up using GUNA. It was difficult initially but we were able to integrate it. We had some issues initially to use foreign keys where required so to overcome that we used tokens in Statics file. We also research about basics of C# as it was new for us along with Visual Studio as it was new environment for us to work. Another challenge was that to decide where to use foreign keys in regards to using it in plain MS Sql server and then accessing it from the frontend. We wanted to use few dependencies in order to generate reports which was a challenge for us. When we create accounts our initial approach was to email username and password to user but after 30 May 2022 it was restricted by Gmail to access any third party software so we ended up using security question and answer to overcome it.
The language that is used is C# and for IDE Visual Studio is primarily used. Basic concepts of OOP along with best database design approach is used with MS Sql Server.
Overall, the project has achieved its objectives. This was an attempt to create a database management system for hotel where a DBA can easily manage the hotels, rooms, bookings, guests, employees, departments, services, etc. and other things as well, easily and quickly. Overall, it is huge area and we tried to cover most of the parts of it. If we see this project in a long run, the world is changing and now everything is digitalize so this will be a productive and to optimize work load of everyone and reduce human efforts and work load and replace manual paper work.
FOR MORE DETAILED EXPLANATION, PLEASE REVIEW OUR PROJECT REPORT WHICH CONTAINS UI IMAGES AND MORE VALUABLE INFORMATION!
HAPPY CODING! :D