A PROPOSAL REPORT

ON
ONLINE HOTEL BOOKING SYSTEM.
A PROJECT REPORT

Submitted by

VAGEESH PALIWAL (20MCA1188),

SHRISTHI (20MCA1189),
VAISHALI MEHTA (20MCA1256).
AISHWARYA GARG (20MCA1172).

IN
MASTER OF COMPUTER APPLICATION

Chandigarh University
February & 2022
INTRODUCTION

“Online Hotel Booking System” is a system based on accessing the internet to book for
rooms in a hotel. The purpose of this study is to develop and implement an online hotel
reservation system for hotels, that will replace the manual method of booking for hotel
rooms. The previous system for booking rooms were faced with so many problems like, delay
in processing the customer booking or paying for rooms that is below or beyond his standard,
causes difficulty for emergency booking.

The objects-oriented analysis and design methodology (OOADM) was therefore used to
analyse the system in order to discover the various objects involved and how they interact
with one another so that a new and improved system can be defined.

The use of online view of room rates and uploading of available rooms and facilities was
used for the new system so that the customer can view and make his choice before arrival,
and also in the case of emergency travelling. This new system assisted the hotel owners in
managing their hotels, because they can also regulate the receptionist moves and avoid
fraudulent activities. It also increased the efficiency of the hotel managers and also their
profit margin, once they have a better and good facilities.

The main purpose of this work is therefore to develop a web application program that would
circumvent all those problems encountered in the manual hotel booking system, so that
customers can easily go online with their mobile phones, tablets or laptops in order to browse
the relevant information they need about the hotels within their locality so that they can book
for the appropriate suite that is within their budget.

Client Identification and Recognition of Need:

To identify the needs of your customers, solicit feedback from your customers at every step
of your process. You can identify customer needs in a number of ways, for example, by
conducting focus groups, listening to your customers or social media, or doing keyword
research.

Recognition & knowledge of relevant contemporary issues.

1. Customers having little or no information about the hotels in their

vicinity.
 2. A guest checking into a hotel room that is either too expensive or
too unbefitting for his or her personality.
3. Prolonged delay by the receptionist in retrieving certain information
about any particular guest on demand.
4. Possibility of fraud by the receptionist in not documenting officially
information about some guests that checked into the hotel rooms.

Project Identification

Project Identification

Name or Title: Hotel Booking System

Description: Develop and implement hotels booking system for employees

Project group: Vageesh paliwal(20mca1188),Shiristhi(20mca1189), Vaishali

Mehta(20mca1256),Aishwarya Garg(20MCA1172).

Date:02/03/2022

Estimated Budget: team work

Task Identification:
The necessary hardware and software infrastructure will be in spot The team will be available
for meetings a minimum of four hours weekly

Timeline of the project (in weeks)

These major pints to be consider in this project as per the time line it will complete on given
time and still working on user panel.
We complete user panel now we starting working admin model and some designing part of
application.
Use of modern project planning tools.

a. Php
b. Xampp
c. MySQL
d. HTML
e. Bootstrap
f. Java Script
i. CSS

Php
Hypertext Preprocessor (or simply PHP) is a server-side scripting language designed for Web
development, but also used as a general-purpose programming language. It was originally
created by Rasmus Lerdorf in 1994,] the PHP reference implementation is now produced by
The PHP Group. PHP originally stood for Personal Home Page, ] but it now stands for the
recursive acronym PHP: Hypertext Preprocessor. PHP code may be embedded into HTML
code, or it can be used in combination with various web template systems, web content
management systems, and web frameworks. PHP code is usually processed by a PHP
interpreter implemented as a module in the web server or as a Common Gateway Interface
(CGI) executable. The web server combines the results of the interpreted and executed PHP
code, which may be any type of data, including images, with the generated web page. PHP
code may also be executed with a command-line interface (CLI) and can be used to
implement standalone graphical applications.

Xampp
XAMPP is a free and open-source cross-platform web server solution stack package
developed by Apache Friends, consisting mainly of the Apache HTTP Server, MariaDB
database, and interpreters for scripts written in the PHP and Perl programming languages.
XAMPP stands for Cross-Platform (X), Apache (A), MariaDB (M), PHP (P) and Perl (P). It
is a simple, lightweight Apache distribution that makes it extremely easy for developers to
create a local web server for testing and deployment purposes. Everything needed to set up a
web server – server application (Apache), database (MariaDB), and scripting language (PHP)
– is included in an extractable file. XAMPP is also cross-platform, which means it works
equally well on 5 Linux, Mac and Windows. Since most actual web server deployments use
the same components as XAMPP, it makes transitioning from a local test server to a live
server extremely easy as well.

MySQL

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.
MySQL Workbench provides data modelling, SQL development, and comprehensive
administration tools for server configuration, user administration, backup, and much more.
MySQL Workbench is available on Windows, Linux and Mac OS X.

HTML

Hypertext Markup Language (HTML) is the standard markup language for creating web
pages and web applications. With Cascading Style Sheets (CSS) and JavaScript, it forms a
triad of cornerstone technologies for the World Wide Web. [4] Web browsers receive HTML
documents from a web server or from local storage and render the documents into multimedia
web pages. HTML describes the structure of a web page semantically and originally included
cues for the appearance of the document. HTML elements are the building blocks of HTML
pages. With HTML constructs, images and other objects such as interactive forms may be
embedded into the rendered page. HTML provides a means to create structured documents by
denoting structural semantics for text such as headings, paragraphs, lists, links, quotes and
other items.

Bootstrap

Bootstrap is a free and open-source front-end framework for designing websites and web
applications. It contains HTML- and CSS-based design templates for typography, forms,
buttons, navigation and other interface components, as well as optional JavaScript extensions.
Unlike many web frameworks, it concerns itself with front-end development only. Java Script
JavaScript often abbreviated as JS, is a high-level, interpreted programming language. It is a
language which is also characterized as dynamic, weakly typed, prototype-based and multi-
paradigm. Alongside HTML and CSS, JavaScript is one of the three core technologies of the
World Wide Web. JavaScript enables interactive web pages and thus is an essential part of
web applications. The vast majority of websites use it, and all major web browsers have a
dedicated JavaScript engine to execute it.

Java Script
JavaScript often abbreviated as JS, is a high-level, interpreted programming language. It is a
language which is also characterized as dynamic, weakly typed, prototype-based and multi-
paradigm. Alongside HTML and CSS, JavaScript is one of the three core technologies of the
World Wide Web. JavaScript enables interactive web pages and thus is an essential part of
web applications. The vast majority of websites use it, and all major web browsers have a
dedicated JavaScript engine to execute it

CSS
Cascading Style Sheets (CSS) is a style sheet language used for describing the presentation of
a document written in a markup language like HTML. CSS is a cornerstone technology of the
World Wide Web, alongside HTML and JavaScript. CSS is designed to enable the separation
of presentation and content, including layout, colors, and fonts. This separation can improve
content accessibility, provide more flexibility and control in the specification of presentation
characteristics, enable multiple web pages to share formatting by specifying the relevant CSS
in a separate CSS file, and reduce complexity and repetition in the structural content.

Hardware specification
HARDWARE SPECIFICATION
Client side
RAM 512 MB

Hard disk 40GB

Processor Intel core duo or higher

Server Side

RAM 2GB OR Higher

 Hard disk 80GB or higher

Processor Intel core duo or higher

Software Specification
Client side
Operating system Windows 7 and above
Microsoft edge
Web Browser Mozilla Firefox
Google chrome
Server Side
Operating System Windows 7 and above
Database server Sql server

Relevant topics identified for literature review:

Online hotel or resort reservations are becoming a very popular method for booking hotel or
resort rooms. Travelers can book rooms from home by using online security to protect their
privacy and financial information and by using several online travel agents to compare prices
and facilities at different hotels.
Most of the hotels and pension houses are now using an automated booking system which
helps them to organized better, easy, secured, effective, fastest way to serve customers;
technologies are now very important to our society because it provides us to have more
reliable and comfortable life, that can improve people’s techniques, procedures and ideas on
how to works automation system.

Booking system refers to the systematic registration of the names and other customers’
information who wanted to check-in and use some facilities and services. It is the used
resource management and booking system for customers and other transactions (source).
Automation of booking system effectiveness is that it helps to the manager, employees and
customers to make it easier and more successful one. These are the advantages of automated
booking system; first in terms of speed, they can process information much more quickly
than humans. This means they are good for controlling machinery that might need to be
adjusted instantly. Then secondly is repetition, automated systems can do the same task over
and over again without getting bored, needing breaks or making mistakes. Third is accuracy,
they can do very detailed work and follow precise instructions without error. Fourth is safety,
automated systems can work in places where it would be unsafe to put a human, for example,
in a nuclear power plant, under water or in space. Fifth is efficiency, they get more done than
humans but cost less to operate. This is because they do need breaks, wages, holidays,
canteens, heating and lighting. The quality of the work done is always of the same standard
being materials are not wasted due to human error. Sixth is adaptability, automated systems
can be reprogrammed to do different tasks.

Asupra, (2001), studied an automated system of billing and reservation for “Pearl Manor
Pension House” Incorporated. After a careful study by the researchers it has been found out
that the employees’ encounters problem with their present system, these problems are: a.
time consuming in processing check-in. b. delayed computation of bills and c. time
consuming processing of reservation. After a careful study of the current system of Pearl
Manor Pension House, Incorporated, the group came with a conclusion to; automate their
system. The automation of the system will give advantages to the company because it will
make the computation of bills a lot easier and more accurate. Processing is faster and more
convenient for both the user and clients. The results of interviews and research study that was
conducted by the researchers lead to form a recommendation of automating the billing and
reservation system of the company. The system will be the one responsible to process all the
transactions.

Review of previous solutions or related materials, Extent and relevance of

the materials and reviewed to the project:

This study focuses only for the Automation of Booking (Check-In-Check-Out) Record
System and Reservation of Hotel and Pension houses. The proposed system emphasizes only
on the reservation check-in and check-out procedure of the customer. Persons involved for
the implementation of this study are specifically the manager, staff members. It is also
concerned to the owner of the pension house for him/her to be well- informed of the proposed
system.

According to Marco Polo (March, 2013) Guesthouse online reservation system is to provide
online room reservation, hotel information and tourist information. The online system had
stated out
the contact person’s number and email clearly. In case visitors have any
questioners, they can call or write to the contact person. Suggestions from guest are good to
help the hotel business growing. Anyway, the online system did not provide an instant
booking system. Guests will have to wait for confirmation within 24 hours after their
booking. To enhance the current system, system is developed to enables guest have
availability checks and instant confirmation of the booking. The purpose of this feature is to
save valuable time and to cut cost, as it will eliminate email exchanges between guests and
reservation department. Valuable reservations staff time is saved because reservation requests
will no longer have to be processed. Although the online system had included the picture for
the bedroom, kitchen and dining room, visitors only can view of it. With a more advance
feature provide in developed system, visitors will be able to view the whole room, for every
angle of the room. The current online system for Marco Polo Guesthouse did not include the
Online Hotel Reservation System (OHRS) (2013). Retrieved on November 26, 2017 9:24pm
from.

management for housekeeping. In addition to enhance the functionality

of developed system, a ‘Housekeeping’ features added for housekeeper to
perform their daily work.
Foreign According to Louw, Door Janne, (2013). Description with UML Hotel Reservation
System. Developed a hotel management system that can be used online. This system allows
the guests to do their booking online by them self. Some of task that the system can do are
providing a query for arriving date and the length of staying, providing the number of On
rooms, view all available rooms and provides user the ability to choose one or more of them,
recording the number of on rooms, view all available rooms and provides the user the ability
to choose one or more of them, recording kind of guests and how many going to be in the
single room, providing the cost of booking, asking the users if they want additional service;
such as, dinner or breakfast, storing the guests detail; like, name, address and telephone,
asking the user for confirmation, final confirmation views with the detail of booking and the
guests can review or cancel the booking.
According to Jun Rey Esparago (2013) Online Hotel Reservation Software (OHRS) is an
easy-to-use arrangement that enables agents and guest to reserve rooms directly via the
internet once they have confirmed.

Summary of how reviewed literature helped in defining problem statement.

ion A growing reliance on the Internet as an information source when making choices about
tourism products raises the need for more research into European Scientific Journal March
2019 edition Vol.15, No.7 ISSN: 1857 – 7881 (Print) e - ISSN 1857- 7431 155 the electronic
word of mouth. Within a hotel context, this study explores the role of four key factors that
influence perceptions of consumer choice. This study developed a research model and
empirically examined the model by collecting data from student travelers at the University of
the Punjab, Lahore. Consumers seem to be more influenced by early negative information,
especially when the overall set of reviews is negative. However, positively framed
information increases both booking intentions and consumer trust. The results suggest that
consumers tend to rely on easy-to-process information when evaluating a hotel based upon
reviews. Online Customer Review provides product information and recommendations from
customers' perspectives to the people who may have a buying intention of the product or
service. Our study examines the impact of the number of online customers considering the
natural cycle for the processing of information. The test system is used to describe the
stimulus of the number of online customers.
Our study examines the impact of the number of online customers considering the natural
cycle for the processing of information. The test system is used to describe the stimulus of the
number of online customer reviews especially the negative ones depending on the
involvement of the customers. If the person wants to book a hotel it does not consider the
negative comments. Negative reviews could not change the intention of the person due to
their need for hotel booking. The largest number of customers involved in the internet makes
a corresponding agreement. As the number of online customers rises, a large number of
people tend to adapt to views by reviewers or customers or shoppers, depending on the
quality of reviews; On the other hand, some customers involved often adapt to the opinion of
reviewers regardless of the quality of online review of customers.

Problem Definition:

Customers having little or no information about the hotels in their vicinity.

A guest checking into a hotel room that is either too expensive or too unbefitting for his or
her personality.

Prolonged delay by the receptionist in retrieving certain information about any particular
guest on demand.

Possibility of fraud by the receptionist in not documenting officially information about some
guests that checked into the hotel rooms.

Goals and Objectives.

Customers can easily go online with their mobile phones or laptops to browse about hotels
within their vicinity.

Guests can be able to book for rooms within their budgets after seeing and accessing these
hotels within their vicinity.

Receptionists can easily access customer’s information online without delay or with little
delay.

Fraud done by the receptionist by not registering every customer will not occur because the
customers details will be online and can be accessed by the managers too.

This study is aimed at finding out how effective the online room reservation or booking
system will improve the operations of room reservations in hotels. However out of the several
departments that makes up the hotel, this research project is restricted to only one section
( room reservation) section.
Feature/Characteristic selection

 Some of the service providers won’t allow you to choose your hotel, they only
allow you to select location and quality of the hotel.
 Considerable discounts on hotels may be available in off-seasons.
 Customer can utilize the serve of online hotel booking service providers when they
are planning for a trip.
 Each and every customer is capable of looking to book their hotel rooms early and
conveniently.
 User can post, update and delete the links in the all categories.
 Online hotel booking is the best way to book rooms in favourite hotels.
 This facility is provided by Online Hotel Management System Project.
 Planning a vacation has never been easier and more reasonable than now.
Easiness, affordable pricing and simple comparison shopping make online hotel
bookings accepted to all.

Constraint Identification

a. Regulations & Design constraints considered in design:

 Designing of the project is main constraint of this project and some models are
difficult to design like admin model and user model.
 Secondly, Configuration which themes better for User perspective.
 Time has been given in this project and every member do their job there are
many modules to create.
 Our time has been spent instead of budget. For designing pattern, we use basic
frontend languages such as html CSS bootstrap.
 b. Economic, environmental, health, manufacturability & safety constraints
considered in design
 There is no problem with economic and environmental and for health or
manufacturability.
 Its totally safe for each and every person
 There is no issue with design also.
 We consider this thing that user easily interact with our product.

c. Professional and ethical issues considered in design

Design ethics concerns moral behaviour and responsible choices in the practice of
design. It guides how designers work with clients, colleagues, and the end users of
products, how they conduct the design process, how they determine the features of
products, and how they assess the ethical significance or moral worth of the products
that result from the activity of designing. Ethical considerations have always played a
role in design thinking, but the development of scientific knowledge and technology
has deepened awareness of the ethical dimensions of design. As designers incorporate
new knowledge of physical and human nature as well as new forms of technology into
their products, people are increasingly aware of the consequences of design for
individuals, societies, cultures, and the natural environment.

Analysis and feature finalization subject to constraint

1. Planning: This includes defining the main goal(s) of the project team, how the team
intends to achieve the goal(s), and the equipment and/or steps that will be taken to do
so.

2. Scheduling: The project management team must plot out the realistic timeframe to
complete each phase of the project.

3. Monitoring: This step occurs once the project is underway and requires the project
team to analyse how the past stages of the project performed, noting trends and
 impacts on future plans, and communicating these findings to all relevant
stakeholders.

4. Control: In the control step, the team must, upon communicating the results of each
phase of the project, move forward accordingly. That means if things are running
smoothly, the team must analyse the factors contributing to that positive outcome so
that it can be continued and replicated. If there has been a derailment, the team must
know how and why the derailment occurred and correct it for future actions.

Generate multiple design alternates.

Develop prototypes that enable a user to understand how human machine interaction will occur.
Record the origin of and the reason for every requirement. Use multiple views of requirements like
building data, function and behavioural models. Work to eliminate ambiguity.
Designing the application architecture involves network technologies and making decisions on how
the system’ data, processes and interfaces are to be distributed. To do this, the data and process
models that were created during the requirement analysis were analysed. The hotel room
reservation system is based on the 3-tier architecture which is made up of three logical tiers i.e., the
Presentation-tier, Middle-tier and Data-tier
 The Presentation-tier: When designing the presentation-tier of this Hotel reservation system,
HTML (a scripting language) together with PHP which is a programming language was used.
 Middle-tier: The middle tier was designed to capture information like: the customer’s login details,
making a reservation, cancelling a reservation, requesting an account and report generation.
 Data- tier: This was designed for error handling. The URL that will generate error was written using
PHP. The hotel reservation system used Java script Form authentication to validate users of the
system.

Client PHP

Middle tier
Selection of best design and implementation plan

This is a phase in which the system analyst did an evaluation of the changeover method that
should be used to switch from present manual system to the developed computerized system.
After a close analysis the analyst came up with parallel changeover method as the most
appropriate for the system. Parallel method is whereby the computerized system will run
concurrently with the manual system before discarding the manual system. Although
expensive the changeover method will prove to be the most efficient because: Parallel
changeover provides time for one the database administrator to update all the guest files
before a total changeover to the new system.
It’s possible to troubleshoot any errors arising from loading process without affecting the
hotel’s
transactions as the manual system will still be in place to carry out the hotel activities
smoothly. Provides time for employees to learn and adapt to the new system. Lowers the risk
to the management in case of a technical hitch or breakdown as the manual system will still
be in place as the analyst fixes the technical hitch

References (APA format)

1-Ba, S., & Pavlou, P. A. (2002). Evidence of the Effect of Trust Building Technology in
Electronic Markets: Price Premiums and Buyer Behaviour. MIS Quarterly, 26(3), 243.
https://doi.org/10.2307/4132332 2. Bickart, B., & Schindler, R. M. (2001).

2. Internet forums as influential sources of consumer information. Journal of Interactive

Marketing, 15(3), 31–40. https://doi.org/10.1002/dir.1014 3. Bulchand-Gidumal, J., Melian-
González, S., & González LopezValcarcel, B. (2013).

3- A social media analysis of the contribution of destinations to client satisfaction with hotels.
International Journal of Hospitality Management, 35, 44–47.
4-https://doi.org/10.1016/j.ijhm.2013.05.003 4. Burgee, L. E., & Steffes, E. M. (2009). Social
ties and online word of mouth. Internet Research, 19(1), 42–59.
https://doi.org/10.1108/10662240910927812.