VISVESVARAYA TECHNOLOGICAL UNIVERSITY

BELAGAVI-590 018, KARNATAKA.

WEB MINI PROJECT REPORT

ON

“HOTEL MANAGEMENT SYSTEM”

PROJECT ASSOCIATES

SHARATH P J 4BD16CS082
SUHAS R A 4BD16CS100

PROJECT GUIDES

Dr. Vinutha H P M.Tech., Ph. D., M.I.S.T.E., Prof. Preethi B B. E., M. Tech.,
Associate Professor, Assistant Professor,
Department of CS&E, Department of CS&E,
B.I.E.T., Davangere. B.I.E.T., Davangere.

Department of Computer Science and Engineering.

Bapuji Institute of Engineering & Technology
Davangere- 577004
December - 2019
 Bapuji Institute of Engineering and Technology
Davangere -577004

Department of Computer Science and Engineering

CERTIFICATE
This is to certify that SHARATH P J and SUHAS R A bearing USN 4BD16CS082
and 4BD16CS100 respectively of Computer Science and Engineering department have
satisfactorily submitted the mini project report entitled “HOSPITAL MANAGEMENT
SYSTEM” for Web Technology Laboratory (15CSL77). The report of the mini project has
been approved as it satisfies the academic requirements in respect of mini project work
prescribed for the year 2019.

Project Guides

Dr. Vinutha H P M. Tech., Ph. D., Prof. Preethi B B.E, M. Tech.,

Associate Professor, Assistant Professor,
Department of CS&E, Department of CS&E,
B.I.E.T., Davangere. B.I.E.T., Davangere.

Head of Department

Dr. Nirmala C R M. Tech., Ph.D., M.I.S.T.E

Profossor & Head,
Department of CS&E,
B.I.E.T., Davangere.

Date: Signature of Examiners:

Place: (1)

(2)
 Bapuji Educational Association (Regd.)
Bapuji Institute of Engineering and Technology, Davangere-577004
Department of Computer Science and Engineering

Vision and Mission of the Department

VISION
To be a center of excellence in imparting state-of-the –art technology in Computer
Science and Engineering education enabling the students to become professionally sound and
ethically strong.

MISSION
M1: Adapting best in class teaching and learning methodology to mould the students to become
industry ready.
M2: Creating conducive environment for imparting quality education to facilitate research and
Innovation
M3: Establishing industry institute relationship to bridge the skill gap.
M4: Educating the students to be successful lifelong learners by inculcating ethical values and
social responsibilities.

PROGRAM EDUCATIONAL OBJECTIVES (PEOs)

PEO1: To provide students with adequate knowledge in mathematics, computer science and
few interdisciplinary courses that gears them for advanced technology
PEO2: To impart core knowledge in both hardware and software with problem
solving techniques.
PEO3: To conduct effective training programs in order to explore and enhance their skills to
Synchronizing with dynamic industry practices.
PEO4: To motivate students for higher studies and to involve in research.

PROGRAM SPECIFIC OUTCOMES (PSOs)

PSO1: Able to understand, analyse and develop simple to complex programs with the help of
knowledge gained from the Computer Science and Engineering subjects.
PSO2: Ability to develop real time, secure and distributed applications related to industry and
society with the knowledge of courses like Artificial Intelligence, Machine Learning, BigData,
Cloud Computing, IOT, Cyber Security and Open Source Platforms

COURSE OUTCOMES (COs)

CO1: Design and develop static and dynamic web pages.
CO2: Familiarize with Client-Side Programming, Server-Side Programming, Active server
Pages.
CO3: Learn Database Connectivity to web applications.
 ACKNOWLEDGMENT

Salutations to our beloved and highly esteemed institute, “BAPUJI INSTITUTE

OF ENGINEERING AND TECHNOLOGY” for having well-qualified staff and labs
furnished with the necessary equipment.

We express our sincere thanks to our guides Dr. Vinutha H P and Prof. Preethi B
for giving us constant encouragement, support and valuable guidance throughout the course
of the project without whose stable guidance this project would not have been achieved.

We express wholehearted gratitude to Dr. Nirmala C R who is our respected

H.O.D of Computer Science and Engineering Department. We wish to acknowledge her
who made our task easy by providing with her valuable help and encouragement.

We also express our wholehearted gratitude to our respected Principal,

Dr. M C Nataraja for his moral support and encouragement.

We would like to extend our gratitude to all staff of Department of Computer

Science and Engineering for the help and support rendered to us. We have benefited a lot
from the feedback, suggestions given by them.

We would like to extend our gratitude to all our family members and friends
especially for their advice and moral support.

SHARATH P J (4BD16CS082)

SUHAS R A (4BD16CS100)
 ABSTRACT

A Hotel management system is a computerized management system. This system

keeps the records of hardware assets besides software of this organization. The proposed
system will keep a track of Workers, Residents, Accounts and generation of report
regarding the present status. This project has GUI based software that will help in storing,
updating and retrieving the information through various user-friendly menu-driven
modules. The project “Hotel Management System” is aimed to develop to maintain the
day-to-day state of admission of Residents, List of Workers etc. Through the Web
Interface User can book the rooms provided through the payment gateways along with
confirmatory Mail notification. Main objective of this project is to provide solution for
hotel to manage most there work using computerized process. This software application
will help admin to handle customers information, room allocation details, payment details,
billing information and handling the complaints.
 CONTENTS

TOPICS PAGE NO.

Chapter 1: INTRODUCTION 01-05

1.1 Web Technology
1.2 Hotel

Chapter 2: LITERATURE SURVEY 06-10

2.1 Summary of Literature Survey
2.2 Existing System
2.3 Problem Identification
2.4 Proposed Solution
2.5 Aims/Objectives

Chapter 3. SOFTWARE REQUIREMENT SPECIFICATION 11-14

3.1 Functional Requirements
3.2 Non-Functional Requirements
3.3 Hardware Requirements
3.4 Software Requirements
3.5 Technologies

Chapter 4. SYSTEM DESIGN 11-14

4.1 System Architecture
4.2 Sequence Diagram
4.3 UML Diagram
4.4 Flowchart
4.5 Relational Schema
4.6 Table Description
4.7 System Modules

Chapter 5. IMPLEMENTATION 29-34

5.1 Installation Steps
5.2 Pseudo Code
Chapter 6. TESTING 35-37
6.1 Overview
6.2 Testing Methods
6.3 Test Cases

Chapter 7. SNAPSHOTS AND RESULTS 38-47

7.1 Front End
7.2 Login Module
7.3 Admin Dashboard
7.4 Guest Room Booking

Chapter 8. CONCLUSION AND FUTURE SCOPE

BIBLIOGRAPHY
 LIST OF FIGURES

SL. NO. FIG. NO. FIGURE NAME PAGE NO.

01 4.1 Architecture Diagram of Hotel Management 15
System

02 4.2 Sequence Diagram for Guest Room Booking 16

System

03 4.3 Use Case Diagram for User 17

04 4.4 Use Case Diagram for Admin 18

05 4.5 Generalized Use Case Diagram 19

06 4.6 Flowchart of Hotel Management System 21

07 4.7 Relational Schema 22

08 7.1 Front Page User Interface 38

09 7.2 Hotel Services 38

10 7.3 Types of Rooms 39

11 7.4 Dining Services 39

12 7.5 Footer page 40

13 7.6 Registration Form 41

14 7.7 Login Form 41

15 7.8 Recover Password 42

16 7.9 Enter Code 42

17 7.10 Reset Password 42

18 7.11 Room Management 43

19 7.12 Room Reservation 43

20 7.13 Staff Management 44

21 7.14 Add Employee 44

22 7.15 Make Complaint 45

23 7.16 Complaint Management 45

24 7.17 Guest Reservation 46

25 7.18 Online Payment through Razorpay 46

26 7.19 Room Booking Successful 47

27 7.20 Room Booking Confirmation Mail 47

 LIST OF TABLES

SL. NO. TABLE NO. TABLE NAME PAGE NO.

01 4.1 Use Case Description 20

02 4.2 Table Description for booking 23

03 4.3 Table Description for complaint 23

04 4.4 Table Description for customer 24

05 4.5 Table Description for emp_history 24

06 4.6 Table Description for id_card_type 24

07 4.7 Table Description for room 25

08 4.8 Table Description for room_type 25

09 4.9 Table Description for shift 25

10 4.10 Table Description for staff 26

11 4.11 Table Description for staff_type 26

12 4.12 Table Description for user 26

 Hotel Management System

CHAPTER 1
INTRODUCTION

1.1 Web Technology

Web technology refers to the means by which computers communicate with each
other using markup languages and multimedia packages. It gives us a way to interact with
hosted information, like websites. Web technology involves the use of hypertext markup
language (HTML) and cascading style sheets (CSS). In order to make websites look and
function a certain way, web developers utilize different languages. The three core languages
that make up the World Wide Web are HTML5, CSS, and JavaScript.

In the IT world, the internet is an essential platform, whether its for developing or for
consumer use. When developing a website, typically three main languages come into play.
These languages are JavaScript, CSS, and HTML. HTML is the backbone of most webpages.
Essentially, it is used to create the structure of how a specific website would look like, from
the headings, to the paragraphs, the body, links, and even images.Markup languages are the
languages in which the web is written. The most common markup language used is HTML,
which uses tags to annotate text so that a computer can then manipulate the text. Most
markup languages are human readable, and use annotations that are distinguishable from the
annotated text. There are many different kinds of markups and languages, but all are
consistent in the way in which they annotate documents.

Hypertext is defined as the arrangement of information inside a database that allows

the user to receive information and to navigate from one document to another by clicking on
highlighted words or pictures inside the primary document. Hypertext is the base of the
World Wide Web, because it enables user to click on other links to get more information.
Hypertext is a term used for all links, whether it appears as texts or other graphical part.

HTML is the conventional markup language used to create and edit web pages and
web applications. HTML is used for creating the basic structure of a website. HTML consists
of different elements preceded by an opening tag, <tag>, and a closing tag, </tag>. The
content between the tags, <html> and </html>, is the content of the webpage. The content
between the tags, <head> and </head>, is the title of the webpage. This text is displayed
between the <title> and </title> tags. The content between the tags, <body> and </body>, is

B.I.E.T., Davangere 1
 Hotel Management System

the main content of the webpage. The content can include links , paragraphs, headings, and
various other elements.

CSS is a style sheet language standard set by W3C (World Wide Web Consortium)
used to create and edit the visual presentation of web pages. CSS allows web developers to
isolate a web page's content and visual styles into separate documents and gives better page
layout control. An external CSS sheet is generally linked to HTML and XHTML, it also can
be linked to XML, SVG, and XUL. HTML and JavaScript, with CSS, is a vital part of
technology used by the majority of interfaces for websites. This is also used in interfaces for
mobile devices making the websites more engaging.

CSS can be incorporated with HTML in 3 different ways; Inline, Internal, and External.

• Inline styles add style to a single element on the page by placing 'style' after the
element you wish to be styled.

Ex: h2 style = "color: blue"

• Internal styles create a style for a single document because the CSS is stored in the
head of the HTML document. Internal styles are placed using a <style> tag around
all style selectors.

Ex: <style>
body {background-color: white;}
/*This is a comment!
'Body' is the selector,
'background-color' is the declaration*/
h2 {color: blue;}
</style>

• External style sheets exist in separate documents from HTML documents, allowing
for better organization of style and structure. An external style sheet can be linked to
all HTML documents making up a web site, allowing a web developer to style the
entire site (all pages) using one document.

JavaScript is a scripting language that is used along with HTML and CSS as the three
core components of the World Wide Web. JavaScript has first-class functions and is used in
most websites. JavaScript does not have any I/O which means that it has to be embedded in

B.I.E.T., Davangere 2
 Hotel Management System

the host environment. JavaScript is also used in PDF documents, game development, and
desktop and mobile applications. JavaScript is most commonly used to make DHTML by
adding client-side behavior to HTML pages.

PHPstands for Hypertext Preprocessor (no, the acronym doesn't follow the name). It is
an open source, server-side, scripting language used for the development of web applications.
By scripting language, we mean a program that is script-based (lines of code) written for the
automation of tasks.

1.2 Hotel

1.2.1 Introduction to Hotel

The hotel proprietors Act, 1956, a hotel is an “Establishment held out by the
proprietor as offering food, drink and if so required, sleeping accommodation, without special
contract to any traveller presenting himself who appears able and willing to pay a reasonable
sum for the services and facilities provided and who is in a fit state to be received”.
The term ‘Hotel’ was used in England in about 1760. Hotel or inn is defined by
British law as a place where a bonafide travelers can receive food and shelter, provided he is
in a position to pay for and is in a fit condition to be received’.
A Hotel or inn may also be defined as an establishment whose primary business is
providing lodging facilities for the general public and which furnishes one or more of the
following services
• Food and Beverage service
• Room service
• Uniformed service
• Laundry service
• Use of furniture etc.

1.2.2 History

Hotel keeping can be traced back to many centuries and its evolution through the ages
has been brought about by Britain’s economical and industrial changes and developments

B.I.E.T., Davangere 3
 Hotel Management System

During the seventh and eight centuries, it was the monasteries that supplied hospitality
to strangers and, as no charge was made for the accommodation; all travelers were expected
to contribute according to their means to the abbey funds. As more people began to travel
their group themselves together, not only for the company, but for mutual protection from
highway men and robbers. Consequently, travelers arrived in groups at a monastery and it
was often difficult to accommodate them all. In the early nineteenth century the concept of a
hotel room in the bedroom, and this period is known as “Golden age of hotel of the Great
Britain and the world”. Hotel proprietors were legally referred to as ‘Common Innkeepers’

The turn of the century saw an era that was called ‘Belle Epoch’ when grand and
luxurious hotel flourished. A few hotels are still operating today. In London and some other
cities attempts have been made to recapture some of the grandeur of the past Vera in the
making of the modern hotels, and bring back the memories the grand hotel and old days.

1.2.3 Hotel Business

Many economists have often described ‘Hotel Business’ as unique and different from
much other business. Hotel is selling both goods and services. It not only provides both
tangible intangible services, but one of its unusual characteristics is also that it is one of the
very few places where production and consumption occur simultaneously; for example,
ordering subsequent preparation, services and consumption of food items.

Both the products and services are offered on credit transaction. No other business
allows the customer an immediate line of credit, for example, the moment he registers, his
credit purchase starts with the room and a sequence of financial charges throughout the
facilities without immediately paying for them at the ‘point of purchase’. For example,
purchase of food in restaurant, drinks in bar valet services, etc. no other business offers as
varied a range of services and products at the same place as hotel business.

Each hotel must offer lodging, food and protection to their guest and assume a
liability for guest property, provide a high standard of hygiene, cleanliness and sanitation and
should confirm to the minimum requirements of the state regarding safe hotel construction
such as height of building, municipal-by-laws, fire and safety standard so no.

B.I.E.T., Davangere 4
 Hotel Management System

1.2.4 Hotel Services

The present-day modern concept of the hotel is not just a place to provide accommodation,
food and beverage, but like city within a city and offering every possible facilities, accommodation,
service and convenience, not just rooms.

There are more facilities like- cosmetic things, hairdryer, lounges, radio and TV etc. There is
a professionally qualified, highly trained, experienced, and efficient courteous staff in smart, clean
uniforms and the staff coming in the contact with guests could understand English. There is a 24hrs
service for reception, information and telephone. There is a plentiful supply of linen, blanket, towels
and so on. Each bedroom is provided with good vacuum jug/ thermos flask with ice cold, boiled
drinking water.

Further additional services such as given below:

• 24-hour reception
• Breakfast buffet
• Bar and Hotel
• Room service
• Air conditioning
• Coffee and tea facilities
• Free Wi-Fi
• Fitness Center
• Conference rooms
• Car hire
• Laundry and dry cleaning
• Parking
• Concierge service

B.I.E.T., Davangere 5
 Hotel Management System

CHAPTER 2
LITERATURE SURVEY

Technology has made a considerable impact on the Hospitality industry in recent

years and will continue to do so with the increasing use of computer, controlled equipment
and the growth of information technology in general” (Jones and Lockwood, 1989, p.6)
Really in the last two decades, technology has become far more advanced and far more
widely used throughout all types of industry. The tourism and hospitality industry are no
exception. Indeed, many tourism and leisure establishments rely on technological systems for
the vast majority of their operations.

They use a range of computer programs from everything to bookings,

communications, security and payments. If a hospitality establishment does not use some
sort of advanced technological system in its operations, it is deemed to be out of date and
disorganized. Indeed, James Bardi begins to outline the importance of these programs by
claiming that “a well-organized reservation system allows hotels to ensure a steady flow of
guests into their properties”. Furthermore, “Profitable business ventures rely on effective
marketing, which includes reviewing people who require hotel products and services,
determining their specific needs, developing products and services that meet those needs, and
making a profit on the sale of those products and services” (Bardi, 2010).

Part of the reason why hotels utilize technological systems in their operations is
because it keeps them up to date in terms of where they are placed in the market. It makes
work easier for staff members, allowing them to work more efficiently and taking away time
consuming activities which can be carried out by the technology. In some hotels, the
utilization of technological systems means that fewer staff members are needed and this saves
considerable costs. For others, especially luxury hotels, this is not the case but it means that
the staff can be free to attend to customers on a more personal basis, thus upholding high
standards. Therefore, it is understandable that 5-star hotels must ensure that they employ the
most advanced technology available. This is because their priority is maintaining their
position and status as a luxury brand, rather than cutting costs, which would be more of a
priority for budget hotels which cater to a lower end market. Therefore, luxury tourist
establishments rely on top quality technological systems. Jones and Lockwood (1989) noted

B.I.E.T., Davangere 6
 Hotel Management System

“Companies have also been able to produce higher quality products because technology has
developed that assists them to do so”.

Pizam claims that revenue management in hotel management is the “business practice
of selling the right inventory to the right customer at the right price at the right time so as to
maximize revenue, profit and market share” (Pizam, 2005, p. 551). With this in mind, hotels
and hotel managers implement revenue management systems which are able to monitor how
many rooms are being reserved and react to this information. If, for example, there is a short
amount of time before the date approaches in which a number of rooms are not sold,
managers can decide to offer discounts to entice people to fill these rooms (Phillips, 2005). A
room which is unsold is more financially damaging to a business than a room which is sold
for a reduced price, due to the perishable nature of the product. The predominant negative
factor of Hotel Management systems is that they are extremely expensive and can therefore
be costly for hotels to maintain. Indeed, Phillips explains that companies with “expensive
and sophisticated revenue management systems are going bankrupt”. This is why five star
hotels are often able to employ them while hotels which are lower down the market are
not.(Phillips, 2005, p. 142).

It is clear that technology used in hospitality establishments it is also used to make

customers’ lives more convenient. Peacock notes “automated hospitality enterprises will
become an increasing feature of the industry, particularly at the budget end of the market, but
the main use of information technology will be in enhancing customer service, rather than
replacing it”. For example, many hotels use technological booking systems which make it
easy for clients to book online and to have all the information they need about the rooms
available to them. They also use technology within the hotel to benefit the customer during
their stay. For example, many have advanced communications systems installed in the rooms
which means that those on business trips can continues with their work while they are guests
at the hotel. Once again, in 5-star hotels, it is all the more important to provide these
facilities; customers pay a lot of money and so expect to have a certain amount of facilities
and quality additions provided for them (Peacock, 1995, p.21).

B.I.E.T., Davangere 7
 Hotel Management System

2.1 Summary of Literature Survey

It is said from the literature survey that technology is becoming far more advanced
and far more widely used throughout the hotel industry. Nowadays hotels like to use the
technological solutions to make the work easier for their staff members allowing them to
work more efficiently and taking away time consuming activities which can be carried out by
the technology which saves considerable costs and time. Hotels implement revenue
management which are able to monitor how many rooms are being reserved and react to this
information by filling rooms in offer price. For some hotels it might be luxury status and
maintain standards to make use of most advanced technology available. Customers pay a lot
of money and so expect to have a certain amount of facilities and quality additions provided
for them.

2.2 Existing System

The existing system is a manual one where all the activities are to be manually performed by
the admin/manager. The system heavily relies on them. All the hotel bookings, room maintenance
details are maintained in ledger book. Any complaints which occur in the hotel are noted and kept
tracked manually along with the expenses occurred. Staff Management is done manually along with
their salary, role, shifts and other basic information. To generate a report the manager has to go
through all the details in the ledger book. The user usually has to go the hotel physically, make
payment and confirm his/her booking.

2.3 Problem Identification

Time Consuming
It is very time consuming and difficult to write each and every entry and exit of customers
into the hotel in the ledger. Also, it takes a lot of time if all the entries are to be repeated say to keep in
another record for safe keeping. It is also time consuming to check for data quickly. In the current
system processes such as making reports becomes time consuming processes.

Editing of data
Manually written data cannot be changed or edited once written. If there is a mistake and the
administrator tried to cancel it out and write it again this would make the ledger dirty and
disorganized. If data is entered incorrectly the entire system gets incorrect while editing wrongly
entered data cannot easily solve errors.

B.I.E.T., Davangere 8
 Hotel Management System

Problem for user to book a Room

A user has to manually go to that hotel and get his reservation confirmed. Although he might
choose to call the hotel and book for a room. But in that case advance payment could not be done and
thus some hotels do not book rooms without advance payment at all.

Data Insecurity
As the data is stored in ledger, it is not a secure place. As the storage media here are files and
books or registers, there are chances of getting this storage media lost, torn, or it may go in the hand
of the wrong person which can destroy the database or it can also be destroyed accidentally. If the
Data goes into the hands of the wrong person, he or she may take advantage of the data. So, security is
the major aspect of the Hotel Management System.

High Data Redundancy and Inconsistency

As mentioned in the current system. Due to maintenance of so many ledger and files there is a
high redundancy of data i.e. same data is recorded repeatedly. This creates an inconsistency problem
when there is a change or deletion in the recorded data.

2.4 Proposed Solution

In “Hotel Management System” we have tried to consider all of the above problems
and propose the solution. The system consists of web interface. The front page provides the
basic hotel details and functionality for admin to login. Upon successful login admin can
control all the activities through the dashboard like Room maintenance, Staff maintenance,
Complaint maintenance, Report generation etc. On the other hand, user can book a room in
advance by entering the details and making an advance payment. On successful payment, the
user receives a confirmation mail along with the booking status and other necessary
information.

2.5 Aims/Objective

The project “Hotel Management System” is aimed to develop to maintain the day-to-
day state of admission/vacation of residents, list of staff, reports etc.

There are following main objectives of the system:

• Admin can allot room to the user with Book Room, Check-in, Check-out
functionalities.
• Admin can add, update and delete Rooms in the hotel.

B.I.E.T., Davangere 9
 Hotel Management System

• Allow admin to add new employees to the system and maintain Staff details.
• Complaint details are maintained and resolved by admin.
• Keeping details about the users, their needs and payment details, reports etc.
• Providing functionality for the user to book room online making an advance payment
and receiving a confirmatory mail.

B.I.E.T., Davangere 10
 Hotel Management System

CHAPTER 3
SOFTWARE REQUIREMENT SPECIFICATIONS

A Software Requirements Specification (SRS) is a description of a software system to

be developed. It lays out function and non-functional requirements and may include set of use
cases that describe user interactions that the software must provide.

The System Requirements Specification is a formal statement of the application’s

functional and operational requirements. It serves as a contract between the developer and the
customer for whom the system is being developed.

3.1 Functional Requirements

In software engineering, a functional requirement defines a function of a system and

its component. A function is described as a set of inputs the behavior and the outputs. The
functional requirements may be technical details, data manipulation and processing and other
specific functionality that defines what a system is supposed to accomplish. It includes the
data and functional process requirements. These are statements of services the system should
provide, how the system should react to particular inputs and how the system should behave
in particular situations. In some cases, the functional requirements may also explicitly state
what the system should not do.

The Functional requirements of the project are:

• The system shows general hotel details at its home page.
• The system should allow the admin to login with his details.
• The system should allow the admin to add, modify and delete rooms in the hotel.
• The system should allow the admin to Book room, perform Check-In and Check-out.
• The system should enable user to add new employees as staff and perform staff
management operations.
• The system provides functionality for the admin to make complaints, keep a note of
them and resolve them.
• The system should provide reports to the admin.
• The system should an interface for the user to book a room by making advance
payment through payment gateway and receive successful booking mail thereafter.

B.I.E.T., Davangere 11
 Hotel Management System

3.2 Non-Functional Requirements

Non-functional requirements are requirements that are not directly concerned with the
specific functions delivered by the system. They may relate to emergent system properties
such as reliability, response time and store occupancy. Alternatively, they may define
constraints on the system such as the capabilities of I/O devices and the data representations
used in system interfaces.
• Flexibility: The system should be flexible to the user with less complexity and user
friendliness.
• Economic Feasibility: The system should be feasible that the price of the system
should not be so high such that one cannot easily afford it.
• Reliability: The system should be reliable. It should not give false recommendation
such that one cannot rely on it.
• Modifiability: It should be easy to modify with the change in requirements coping up
for the updates easily.
• Portability: It should be possible to port the software system from one machine to
another without any significant overhead.
• Scalability: The system should be scalable to use with many numbers of machines.

3.3 Hardware Requirements

The hardware required for the development of the project is:
• Processor: Intel Core i5 8th gen
• RAM: 4GB
• Hard Disk: 500GB

3.4 Software Requirements

The software required for the development of the project is:
• Operating System: Windows 10
• Database Environment: MySQL 5.7.19
• IDE: VS Code
• Browser: Google Chrome 79.0
• Web Server: XAMPP Server
• SMTP Server: Mailtrap

B.I.E.T., Davangere 12
 Hotel Management System

3.5 Technologies

1. XAMPP Server
XAMPP is a free and open source software which empowers technologies,
processes, and machines to link and work together. It is established by Apache. It stands
for x-OS, Apache, MySQL, PHP, and Perl and used as a stage for coding and designing
web pages.
XAMPP is very easy to install and has the capability to run on several platforms.
XAMPP has very strict security settings and with a single command it can start and stop
the server.

2. MySQL
It is an open source relational database management system which aims to offer
multiple user access to several databases. Since MySQL is a relational database so it
stores data in different tables instead of putting into a large storeroom. Storing /organizing
data into tables increases the accessibility speed and flexibility.

3. Microsoft Visual Studio

Microsoft Visual Studio is an unrestricted, plain text editor used widely by
developers for Microsoft Windows. Visual Studio supports several languages and is used
to write and edit code. In this project Visual Studio is used to write HTML, CSS, PHP
and JavaScript codes. Its main features include syntax highlighting, correcting and auto-
completion.

4. Programming Languages
In this project, PHP was chosen as a server-side programming language and
MySQL was selected as a backend database. HTML, CSS, and JavaScript were used for
the client-side work.

5. Composer
Composer is an application-level package manager for the PHP programming
language that provides a standard format for managing dependencies of PHP software and
required libraries. Composer runs from the command line and installs dependencies (e.g.
libraries) for an application. In this project, we have used Composer to install PHPMailer
to the application.

B.I.E.T., Davangere 13
 Hotel Management System

6. PHPMailer
PHPMailer is a code library and used to send emails safely and easily via PHP
code from a web server. Sending emails directly via PHP code requires a high-level
familiarity to SMTP standard protocol and related issues and vulnerabilities about Email
injection for spamming. PHPMailer simplifies the process of sending emails and it is very
easy to use.

7. Razorpay
Razorpay is a payments solution which allows businesses to accept, process and
disburse payments with its product suite. It gives you access to all payment modes
including credit card, debit card, net banking, UPI and popular wallets. Razorpay
provides clean, developer-friendly APIs and hassle-free integration by offering a fast,
affordable and secure way for merchants, schools, e-commerce and other companies to
accept payments online.

8. Mailtrap
An SMTP (Simple Mail Transfer Protocol) server is an application that’s primary
purpose is to send, receive, and/or relay outgoing mail between email senders and
receivers. Mailtrap provides a fake SMTP server for your development team to test, view
and share emails sent from the pre-production environments and test with real data
without the risk of spamming real customers.

B.I.E.T., Davangere 14
 Hotel Management System

CHAPTER 4
SYSTEM DESIGN

Once the system requirements have been defined, the next stage is the system design
process which deals with defining the architecture, components, interfaces and data for the
system to satisfy specified requirements.

4.1 System Architecture

System architecture is the conceptual model that defines the structure, behaviour and
more views of a system. Architecture is a formal description and representation of a system,
organized in a way that supports reasoning about the structure of the system which comprises
system components, the externally visible properties of those components, the relationships
between them and provides a plan from which products can be procured and systems
developed.

The architecture diagram for Hotel Management System is shown below. It consists
of the web interface both admin and user. The admin can log in and access Booking Module,
Staff Management Module, Complaint Module and Report Module. They are in turn
connected to the database. User can directly book a room when he does the payment through
payment gateway followed by confirmatory mail.

Fig 4.1: Architecture Diagram of Hotel Management System

B.I.E.T., Davangere 15
 Hotel Management System

4.2 Sequence Diagram

A sequence diagram is a model that describes how group of objects collaborate in

some behaviour overtime. The sequence diagram captures the behaviour of a single use case
and shows the object and messages that are passed between these objects in the time frame of
the specific use case. The sequence diagram doesn’t show the relationship between the
objects.

The sequence diagram might also be used to:

• Describe the overall sequence of the flow of control when there are many short
methods in different classes.
• Show current processes and activation.
• Show time sequence that are not easily depicted in a collaboration diagram.
• Show general forms that do not deal with objects but with the class interaction.

Fig 4.2: Sequence Diagram for Guest Room Booking System

B.I.E.T., Davangere 16
 Hotel Management System

The above figure shows the sequence diagram of Guest Room Booking system. First
the user visits the website and requests for the room availability. If the rooms are available,
the user selects the available room, Check-In and Check-Out details along with personal
information of the customer. Now the website calculates the amount to be paid by the user
based on type of room and number of days of stay. We have used Razorpay payment gateway
by which user can pay the required amount through various means at his/her convenience.
Upon successful payment, the room is booked and details are stored in the database. Also, the
Mail Server is se up that the confirmation details is sent to the user after successful booking.

4.3 UML Diagram

The Use Case Model figure shows the proposed system. It defines the conceptual
view of a database. It works around real-world entities and the associations among them. At
view level, the Use Case model is considered a good option for designing the proposed idea.

Fig 4.3: Use Case Diagram for User

B.I.E.T., Davangere 17
 Hotel Management System

Fig 4.4: Use Case Diagram for Admin

B.I.E.T., Davangere 18
 Hotel Management System

Fig 4.5 Generalised Use Case Diagram

B.I.E.T., Davangere 19
 Hotel Management System

Activity Description
Login Admin can Login using valid credentials.
Add Room Admin can add new rooms to the system.
Update Room Admin can update existing rooms in the system.
Delete Room Admin can remove existing rooms from the system.
Both Admin and User can check room availability status in the
Check Room Availability
system.
Both Admin and User can Book room after providing all
Book Room
necessary information.
User has to make online payment to confirm the room booking
Online Payment
with the help of payment gateway.
User receives confirmation mail to the provided mail address
Confirmation Mail
sent by the system’s mail service.
Check In Admin can perform Check In operation upon arrival of guests.
Admin can perform Check Out operation during guest’s
Check Out
departure.
Add Employee Admin can add new employee to the system.
Update Employee Admin can update existing employee details in the system.
Delete Employee Admin can remove existing employee from the system.
Complaints Admin can keep track of complaints in the system
Statistics Admin can get statistics and report of the system.
Logout Admin can logout of the system.

Table 4.1: Use Case Description

4.4 Flowchart

Flowchart is a graphical or symbolic representation of a process. Each step in the

process is represented by a different symbol and contains a short description of the process
step. The flowchart symbols are linked together with arrows showing the process flow
direction. The diagram shows the interdependent and parallel processes over the course of the
project’s life cycle.

B.I.E.T., Davangere 20
 Hotel Management System

Fig 4.6: Flowchart of Hotel Management System

The above diagram shows the flowchart of Hotel Management System. First
both the user and admin are greeted to the home page. If the person is an admin, he can login
through his credentials where he can perform various activities like room management, staff
management, complaint management, report generation and logout. Whereas if the person is
a normal user, he can book a room by making online payment for which he/she receives
email confirmation.

B.I.E.T., Davangere 21
 Hotel Management System

4.5 Relational Schema

Relational schema refers to the meta-data that describes the structure of data within a
certain domain. It is the blueprint of a database that outlines the way its structure organizes
data into tables.

Fig 4.7: Relational Schema

B.I.E.T., Davangere 22
 Hotel Management System

4.6 Table Descriptions

• booking
Column Type Null Default Extra Links to

booking_id int(10) No Auto increment

customer_id int(10) No customer.customer_id

ON UPDATE RESTRICT
ON DELETE RESTRICT
room_id int(10) No room.room_id
ON UPDATE RESTRICT
ON DELETE RESTRICT
booking_date timestamp No CURRENT_TIMESTAMP

check_in varchar(100) Yes NULL

check_out varchar(100) No

total_price int(10) No
remaining_price int(10) No
payment_status tinyint(1) No

Table 4.2: Table Description for booking

Description: This table is used to store booking information when the user or admin books a
room in the system

• complaint
Column Type Null Default Extra

id int(11) No auto increment

complainant_name varchar(100) No

complaint_type varchar(100)
) No

complaint varchar(200)
) No

created_at timestamp
) No CURRENT_TIMESTAMP

resolve_status tinyint(1) No
resolve_date timestamp Yes CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP

budget int(11) Yes NULL

Table 4.3: Table Description for complaint

Description: This table stores data related to complaints and their resolvent details.

B.I.E.T., Davangere 23
 Hotel Management System

• customer
Column Type Null Default Extra Links to

customer_id int(10) No auto_increment

customer_name varchar(100) No

contact_no bigint(20)
) No
email varchar(100) No

id_card_type_id int(10)
) No id_card_type.id_card_type_id
ON UPDATE RESTRICT
ON DELETE RESTRICT

id_card_no bigint(20) No
address varchar(100) No

)
Table 4.4: Table Description for customer
Description: This table stores data related to customer.

• emp_history
Column Type Null Default Extra Links to

id int(11) No auto_increment
emp_id int(11) No -> staff.emp_id
ON UPDATE RESTRICT
ON DELETE RESTRICT
shift_id int(11) No -> shift.shift_id
ON UPDATE RESTRICT
ON DELETE RESTRICT
from_date timestamp No CURRENT_TIMESTAMP

to_date timestamp No 0000-00-00

00:00:00
created_at timestamp No CURRENT_TIMESTAMP

Table 4.5: Table Description for emp_history

Description: This table stores data related to the staff and their past details.

• id_card_type
Column Type Null Default Extra Links to

id_card_type_id int(10) No auto_increment

id_card_type varchar(100) No

)
Table 4.6: Table Description for id_card_type
Description: This table stores data related to type of id card being issued.

B.I.E.T., Davangere 24
 Hotel Management System

• room

Column Type Null Default Extra Links to

room_id int(10) No auto_increment
room_type_id int(10) No room_type.room_type_id
ON UPDATE RESTRICT
ON DELETE RESTRICT
room_no varchar(10) No
status tinyint(1) Yes NULL
check_in_status tinyint(1) No
check_out_status tinyint(1) No

deleteStatus tinyint(1) Yes 0

Table 4.7: Table Description for room

Description: This table stores the details about the various rooms available along with their
status

• room_type

Column Type Null Default Extra Links to

room_type_id int(10) No auto_increment

room_type varchar(100) No

price int(10) No
max_person int(10) No

Table 4.8: Table Description for room_type

Description: This table stores the data about the various types of rooms in the system.

• shift

Column Type Null Default Extra Links to

shift_id int(10) No auto_increment

shift varchar(100) No

shift_timing varchar(100)
)_ No

)
Table 4.9: Table Description for shift
Description: This table stores the data about the shift details of the staff working in the hotel.

B.I.E.T., Davangere 25
 Hotel Management System

• staff
Column Type Null Default Extra Links to

emp_id int(11) No auto_increment

emp_name varchar(100) No

staff_type_id int(11) No staff_type.staff_type_id

ON UPDATE RESTRICT
ON DELETE RESTRICT
shift_id int(11) No shift.shift_id
ON UPDATE RESTRICT
ON DELETE RESTRICT
id_card_type int(11) No id_card_type.id_card_type_id
ON UPDATE RESTRICT
ON DELETE RESTRICT

id_card_no bigint(20) No
address varchar(100) No

contact_no bigint(20) No
salary bigint(20) No
joining_date timestamp No CURRENT_TIMES
TAMP
updated_at timestamp No CURRENT_TIMES on update
TAMP CURRENT_TIMESTAMP

Table 4.10: Table Description for staff

Description: This table stores all the staff details.

• staff_type
Column Type Null Default Extra Links to

staff_type_id int(10) No auto_increment

staff_type varchar(100) No

)
Table 4.11: Table Description for staff_type
Description: This table details of type of staff.

• user
Column Type Null Default Extra Links to

id int(11) No auto_increment
name varchar(100) No

username varchar(15)
) No
email varchar(100) No

password varchar(100)
) No

created_at timestamp
) No CURRENT_TIMESTAMP

Table 4.12: Table Description for user

Description: This table stores all the staff details.

B.I.E.T., Davangere 26
 Hotel Management System

4.7 System Modules

Our application has following modules:

• Admin Login
• Room Management
• Staff Management
• Complaint Management
• Statistics Module
• Payment Module
• Mailing System

Admin Login
This module provides an interface for the admin to login. Valid login credentials i.e.
the Email ID and password should be provided at the time of login. As soon as the admin
logs in, he is greeted with admin dashboard where he is able to control and monitor all the
activities of the system.

Room Management
Room Management module enables admin to add, delete and update new rooms into
the system. He is also able to book room directly. When the guest arrives, he is supposed to
perform the check-in process and check-out process and bill generation while leaving.

Staff Management
Staff Management module provides authority to the admin to add new employees as
staff members by assigning them various roles, shift timings and salary. He can update or
delete employee details at any point of time.

Complaint Management
Complaint Management module provides facilities for all the admins across the
system to make a complaint and raise an issue, so that other admin can keep track of these
issues and resolve these issues later on. Also, the budget spent on it could also be kept track
off.

B.I.E.T., Davangere 27
 Hotel Management System

Statistics Module
Statistics module can help the admin to get insights of the system. He can generate
reports in a timely manner. He can keep track of the customers visiting the hotel. It can help
the owner to make useful decisions using these reports.

Payment Module
Whenever the user tries to book a room using Hotel Management System, Payment
module comes into picture. For this project we are using Razorpay Payment Gateway which
is secure and provides flexibility for the user to pay using various forms. Once the advance
payment is done confirmation mail is sent stating that booking is confirmed.

Mailing System
Once the user tries to book a room online, he is supposed to make advance online
payment. Upon successful payment the user receives booking successful mail along with
other booking related details. For this purpose, the system uses PHPMailer service to send
mail and Mailtrap SMTP server.

B.I.E.T., Davangere 28
 Hotel Management System

CHAPTER 5
IMPLEMENTATION

Implementation literally means to put into effect or carry out. The system
implementation face of the software deals with the translation of the design specifications
into the source code. The ultimate goal of the implementation is to write the source code and
the internal documentation so that it can be verified easily. The code and the documentation
should be written in a manner that uses testing, debugging and modification.
A post-implementation review is an evaluation of the extent to which the system
accomplishes stated objectives and actual project costs exceed initial estimates. It is usually a
review of major problems that need converting and those that surface during the
implementation stage.

5.1 Installation Steps

5.1.1 XAMPP Server Installation Steps

1. Open the XAMPP website. Go to https://www.apachefriends.org/index.html in your
computer's web browser.
2. Click XAMPP for Windows. It's a grey button near the bottom of the page.
Depending on your browser, you may first have to select a save location or verify the
download.
3. Double-click the downloaded file. This file should be named something like xampp-
win32-7.2.4-0-VC15-installer, and you'll find it in the default downloads location
(e.g., the "Downloads" folder or the desktop).
4. Click yes when prompted. This will open the XAMPP setup window. You may have
to click OK on a warning if you have User Account Control (UAC) activated on your
computer.
5. Click Next. It's at the bottom of the setup window.
6. Select aspects of XAMPP to install. Review the list of XAMPP attributes on the left
side of the window; if you see an attribute that you don't want to install as part of
XAMPP, uncheck its box. By default, all attributes are included in your XAMPP
installation.
7. Click Next. It's at the bottom of the window.

B.I.E.T., Davangere 29
 Hotel Management System

8. Select an installation location. Click the folder-shaped icon to the right of the current
installation destination, then click a folder on your computer. If you have the UAC
activated on your computer, avoid installing XAMPP in your hard drive's folder (e.g.,
OS (C:)). You can select a folder (e.g., Desktop) and then click Make New Folder to
create a new folder and select it as the installation destination.
9. Click OK. Doing so confirms your selected folder as your XAMPP installation
location.
10. Click Next. You'll find it at the bottom of the page.
11. Uncheck the "Learn more about Bitnami" box, then click Next. The "Learn more
about Bitnami" box is in the middle of the page.
12. Begin installing XAMPP. Click Next at the bottom of the window to do so. XAMPP
will begin installing its files into the folder that you selected.
13. Click Finish when prompted. It's at the bottom of the XAMPP window. Doing so will
close the window and open the XAMPP Control Panel, which is where you’ll access
your servers.
14. Select a language. Check the box next to the American flag for English, or check the
box next to the German flag for German.
15. Click Save. Doing so opens the main Control Panel page.
16. Start XAMPP from its installation point. If you need to open the XAMPP Control
Panel in the future, you can do so by opening the folder in which you installed
XAMPP, right-clicking the orange-and-white xampp-control icon, clicking Run as
administrator, and clicking Yes when prompted. When you do this, you'll see red X
marks to the left of each server type (e.g., "Apache"). Clicking one of these will
prompt you to click Yes if you want to install the server type's software on your
computer. Counter intuitively, double-clicking the xampp_start icon doesn't start
XAMPP.
17. Resolve issues with Apache refusing to run. On some Windows 10 computers,
Apache won't run due to a "blocked port". This can happen for a couple of reasons,
but there's a relatively easy fix:
• Click Config to the right of the "Apache" heading.
• Click Apache (httpd.conf) in the menu.
• Scroll down to the "Listen 80" section (you can press Ctrl + F and type in
listen 80 to find it faster).

B.I.E.T., Davangere 30
 Hotel Management System

• Replace 80 with any open port (e.g., 81 or 9080 ).

• Press Ctrl + S to save the changes, then exit the text editor.
• Restart XAMPP by clicking Quit and then re-opening it in administrator
mode from its folder.

5.1.2 Microsoft Visual Studio Installation Steps

1. We can download Visual Studio Community Edition 2015 from the following the
https://visualstudio.microsoft.com/downloads/. After entering the Visual Studio
download page, click “Free download” from Visual Studio Community menu.
2. Now, you will be redirected to another page with a pop up showing you the VS
package name. Click on "Save File” on the
“vs_community_ENU__266050523.1487883645.exe” will be downloaded. Now, it
will ask for save location; jus select a location and click "Save".
3. Double click “vs_community_ENU__266050523.1487883645.exe” and click "Run".
4. Select your installation location and type of installation. If you want to install all
features, select default; if you want to install specified features, select custom.
Finally, click the "Install" button.
5. You can see the two progress bars for Acquiring and Applying, as shown in below
screenshot. It will take some time to finish the installation.
6. The "finished installation screen" will look like below. Just click "Restart Now". Your
system will be restarted.
7. After the restart, go to Start button >> All programs >> double click Visual Studio
2015.
8. Visual Studio 2015 will open. We can sign in using Hotmail or Outlook mail Id. If
you want to use it without signing in, just click “Not now, maybe later”.
9. Now, the development settings are selected “General” by default. If needed, we can
change that based on our requirement. Finally, chose color themes and click "Start
Visual Studio".
10. It will take few minutes to open Visual Studio for the first time.

B.I.E.T., Davangere 31
 Hotel Management System

5.1.3 PHPMailer Installation using Composer

1. Go to https://getcomposer.org/download/. Composer is a dependency manager for

PHP, which means it manages everything your PHP code needs, including libraries
and extensions. This is also the easiest method of installing and managing PHPMailer.
You'll find the link to download under the “Windows Installer” header.

2. Click the downloaded file to start the installation process. Follow the instructions on-
screen to install Composer. Choose a PHP executable when prompted to “choose the
command-line PHP you want to use.” All executables will end in .exe.

3. Create a new “Composer” folder. You'll want to navigate in file browser to the
location you will eventually install Composer. Navigate to and double-click the
XAMPP partition in your file browser, right-click and choose to “Add a New Folder”
and name it “Composer.”

4. Search for and open “Command Prompt” in your Start Menu. You can also access the
search window by pressing ⊞Win + S . A command-line terminal will load.

5. Navigate to the directory where you want to install PHPMailer. For example, type cd
C : / xam pp/ com poser . The terminal will confirm it's in that folder.

6. Type "com poser r equ i re phpm ai l er/ phpm ai l er " and press ↵ Enter . Terminal

will display a wall of text as it installs Composer.

7. Composer is installed with an “autoload.php” file you can use.

5.2 Pseudo code

function login()
{
enter valid Login ID;
enter valid Password;
click on Login Button;
}

B.I.E.T., Davangere 32
 Hotel Management System

function admin_reserve_room()
{
select type of room in the drop-down list: Single, Double, Triple or family;
rooms available for that particular type of room is displayed in the drop-down list. Select
one of the rooms;
then select the check-in and check-out dates in the calendar. Number of days and total
price is auto-calculated and showed to the user;
fill the customer details: Name, Contact No., Email Address, ID Card and Address;
click on submit to book the room;
}

function add_employee()
{
select the type of the staff from the drop-down menu;
from the drop-down list select the shift on which the employee works;
then add the employee details: Name, Contact No., Email Address, ID Card, Address and
salary;
}

function add_complaint()
{
select the admin name;
provide the type of complaint;
then give the description of the complaint;
}

function user_book_room()
{
select type of room in the drop-down list: Single, Double, Triple or family;
rooms available for that particular type of room is displayed in the drop-down list. Select
one of the rooms;
then select the check-in and check-out dates in the calendar. Number of days and total
price is auto-calculated and showed to the user;
fill the customer details: Name, Contact No., Email Address, ID Card and Address;

B.I.E.T., Davangere 33
 Hotel Management System

click on submit to book the room. The user is prompted to the payment gateway;
user makes payment of requested amount to the payment gateway through various means;
upon successful booking, the user receives a confirmation mail to his provided mail
address;
}

B.I.E.T., Davangere 34
 Hotel Management System

CHAPTER 6
TESTING

6.1 Overview

Software testing is an investigation conducted to provide stakeholders with

information about the quality of the product or service under test. Software Testing also
provides an objective, independent view of the software to allow the business to appreciate
and understand the risks at implementation of the software. Test techniques include, but are
not limited to, the process of executing a program or application with the intent of finding
software bugs. Software Testing can also be stated as the process of validating and verifying
that a software program/application/product:
• Meets the business and technical requirements that guided its design and
development.
• Works as expected and can be implemented with the same characteristics

6.2 Testing Methods

6.2.1 Functional Testing

Functional tests provide systematic demonstrations that functions tested are available
as specified by the business and technical requirements, system documentation, and user
manuals.
Functional testing is based on the following items:
• Valid messages: Identified classes of valid messages must be accepted.
• Invalid messages: Identified classes of invalid messages must be rejected.
• Functions: Identified functions must be exercised.
• Output: Identified classes of application outputs must be exercised.
• Systems/Procedures: Interfacing systems or procedures must be invoked

6.2.2 Integration Testing

Software integration testing is the incremental integration testing of two or more

integrated software components on a single platform to produce failures caused by interface
defects

B.I.E.T., Davangere 35
 Hotel Management System

6.3 Test Cases

Case 1: Admin Login Module

Sl.No Actual Input Excepted Result Pass/Fail

1 Enter valid name and password Admin Dashboard is displayed. Pass
& click on login button
2 Enter invalid credentials and Admin Dashboard is not displayed. Pass
login

Case 2: Room Management Module

Sl.No Actual Input Excepted Result Pass/Fail

1 Click on Add Room Once the admin types Room type and Room Pass
No., new Room is created
2 Click on Book Room Once the admin enters valid room information Pass
and correct details, room is booked
3 Click on Check-In After the room is booked, admin can Check-In Pass
with optional advance partial payment.
4 Click on Check-Out After the room is Checked-In, admin can Check- Pass
out the room only after clearing the payment

Case 3: Staff Management Module

Sl.No Actual Input Excepted Result Pass/Fail

1 Click on Add Employee Admin can add new Employees to the Pass
database after providing valid information.
2 Click on Change Shift Admin can change the working shift of an Pass
employee.
3 Click on Employee Upon clicking Employee History, admin can Pass
History view Employee details and past working
shifts for the organization.

B.I.E.T., Davangere 36
 Hotel Management System

Case 4: Complaint Management Module

Sl.No Actual Input Excepted Result Pass/Fail

1 Submit on Make Complaint Admin can enter valid complaint details Pass
which is stored in the database
2 Resolve Complaint Admin can resolve a particular complaint Pass
by entering the expense incurred as
budget.

Case 5: Payment Module

Since the project is deployed in test mode, the user have the liberty to accept the
payment or reject the payment for demonstration/testing purpose

Sl.No Actual Input Excepted Result Pass/Fail

1 ACCEPT Payment Advance room booking is done by the user and Pass
amount is paid to the hotel management
2 REJECT Payment No booking is done and hence no payment is Pass
done to the hotel management.

Case 6: Mailing System

Sl.No Actual Input Excepted Result Pass/Fail

1 Payment Successful Confirmation mail is sent stating that booking Pass
is successful along with relevant information
to the mail address provided by the user
2 Payment Unsuccessful No Mail is sent. Pass

B.I.E.T., Davangere 37
 Hotel Management System

CHAPTER 7
SNAPSHOTS AND RESULTS

7.1 Front End

Fig 7.1: Front Page User Interface

Description: Figure showing the contents of the front end and the connectivity to the other
pages.

Fig 7.2: Hotel Services

Description: Figure showing some of the high-end facilities of the hotel.

B.I.E.T., Davangere 38
 Hotel Management System

Fig 7.3: Types of Rooms

Description: Figure showing various types of rooms available in the hotel along with their
information.

Fig 7.4: Dining Services

Description: Figure showing food menu available for the customers to order.

B.I.E.T., Davangere 39
 Hotel Management System

Fig 7.5: Footer page

Description: Figure showing Newsletter sign up page and the webpage footer which contains
relevant links and necessary information regarding the hotel.

B.I.E.T., Davangere 40
 Hotel Management System

7.2 Login Module

Fig 7.6: Registration Form

Description: This form enables new admin to get registered.

Fig 7.7: Login Form

Description: This page enables the admin to login using the credentials.

B.I.E.T., Davangere 41
 Hotel Management System

Fig 7.8: Recover Password

Description: The figure shows Email to be entered in order to recover password.

Fig 7.9: Enter Code

Description: The figure shows the confirmation code received in email to be entered in order
to recover password

Fig 7.10: Reset Password

Description: The figure shows new password to be typed in order to reset it.

B.I.E.T., Davangere 42
 Hotel Management System

7.3 Admin Dashboard

Fig 7.11: Room Management

Description: The figure shows the room management options such as add room, book room,
Check-In, Check-Out, etc.

Fig 7.12: Room Reservation

Description: The figure shows the form to be filled by the admin to book rooms.

B.I.E.T., Davangere 43
 Hotel Management System

Fig 7.13: Staff Management

Description: The figure shows the staff management functions available to the admin.

Fig 7.14: Add Employee

Description: The figure shows the form to be filled by the admin to add new employee to the
system.

B.I.E.T., Davangere 44
 Hotel Management System

Fig 7.15: Make Complaint

Description: The figure shows the form which admin fills if a complaint is found in the
system.

Fig 7.16: Complaint Management

Description: The figure shows the complaint management operations that admin can perform
to resolve the complaint with necessary expenditure.

B.I.E.T., Davangere 45
 Hotel Management System

7.4 Guest Room Booking

Fig 7.17: Guest Reservation

Description: The figure shows the form to be filled by the user to book rooms.

Fig 7.18: Online Payment through Razorpay

Description: The figure shows the payment done through Razorpay for requested amount.

B.I.E.T., Davangere 46
 Hotel Management System

Fig 7.19: Room Booking Successful

Description: The figure shows the successful room booking status upon successful payment.

Fig 7.20: Room Booking Confirmation Mail

Description: The figure shows the snapshot of SMTP server used to send confirmation mail
to the customer through the provided mail address.

B.I.E.T., Davangere 47
 Hotel Management System

CHAPTER 8

CONCLUSION AND FUTURE SCOPE

Conclusion
“HOTEL MANAGEMENT SYSTEM” is successfully designed and developed to
fulfill the necessary requirements, as identified in the literature survey. The system aims
providing friendly and easy-to-use environment for Hotel Administrator to meet the modern
day requirements. The major functionalities of the project are to perform activites like Room
management, Staff management and Complaint management along with the ability for the
user to book rooms online is easy to use and reduces manual efforts. Various modern
technologies and frameworks are used to successfully complete the project.

Future scope:

The project has been developed in a very short period of time and all efforts have
been taken so that the project is very efficient in its execution. There still exists some scope
of improvement in our project. The following losts some of the enhancement that can be
added incorporate into the project:

• Integrating a Real-time chatbot for checking availability status and answering basic
questions of the customers.
• Using of Messaging service so that, the user is notified each time the user books a
room, checks-in or checks-out for convenience and security purpose as well.
• Developing advanced reports and analytics on the captured data so that the admin
would get the business insights of the system.

B.I.E.T., Davangere 48
 BIBILOGRAPHY

BOOKS:

[1] Randy Connolly, Ricardo Hoar, "Fundamentals of Web Development”, 1st Edition,
Pearson Education India. (ISBN:978-9332575271)
[2] Robert W. Sebesta, “Programming the World Wide Web”, 8th Edition, Pearson
Education India. (ISBN: 978-8131764589)
[3] Robin Nixon, “Learning PHP, MySQL &JavaScript with jQuery, CSS and HTML5”, 4th
Edition, O’Reilly Publications, 2015. (ISBN:978-9352130153)
[4] Luke Welling, Laura Thomson, “PHP and MySQL Web Development”, 5th Edition, Pearson
Education, 2016. (ISBN:978-9332582736)
[5] Nicholas C Zakas, “Professional JavaScript for Web Developers”, 3rd Edition, Wrox/Wiley
India, 2012. (ISBN:978-8126535088)

WEBSITES:

• https://github.com/PHPMailer/PHPMailer
• https://razorpay.com/docs/payment-gateway/
• https://w3schools.com
• https://www.udemy.com/course/php-mysql-login-and-registration-system-with-email-
confirm-activation/