Chapter 1

Introduction

"Online Hotel Management System" is a web application. This system is developed to

automate day to day activity of a restaurant. Restaurant is a kind of business that serves people
all over world with readymade food. This system is developed to provide service facility to
restaurant and also to the customer. This restaurant management system can be used by
employees in a restaurant to handle the clients, their orders and can help them easily find free
tables or place orders. The services that are provided is food ordering and reservation table
management by the customer through the system online.

The services that are provided is food ordering and reservation table management by the
customer through the system online, customer information management and waiter information
management, menu information management and report. The restaurant menu is organized by
categories (appetizers, soups, salads, entrees, sides and drinks) of menu items. Main objective
build the system this is to provide ordering and reservation service by online to the customer.
Each menu item has a name, price and associated recipe.

A recipe for a menu item has a chef, preparation instruction sand associated ingredients. With
this system online, ordering and reservation management will become easier and systematic to
replace traditional system where are still using paper. To resister a meal online, the customer has
to become a member first then he can access the later part of the site. this project to facilitate
customer for make online ordering and reservation. the fake The option of becoming member
was only an attempt to avoid (to some extent) placing bookings.

Online Hotel management system is the system for manage the restaurant business. After
successful login the customer can access the menu page with the items listed according to the
desired time. The main point of developing this system is to help restaurant administrator
manage the restaurant business and help customer for online ordering and reserve table. In
proposed system user can search for a menu according to his choice
such as customer ordering and reservation table. If the customer book an order and later wants to
cancel the order, he is permitted to do this only within a specific time period.

1
 Chapter 2

Technology/Platform to be used
2.1 Introduction To HTML
One language that is specially designed to convert the simple text into Hypertext is also known
as Hypertext Markup Language (HTML). HTML is the collection of some codes (typically
known as tags) that have some special meanings. Each HTML tag has a proper effect on the
simple text. Any HTML document is fully portable and can be understood by any browser.

2.1.Features of HTML:

 It is the language which can be easily understand and can be modified.

 It provides the more flexible way to deign web pages along with the text.
 Links can also be added to the web pages so it help the readers to browse the information
of their interest.
 We can display HTML documents on any platforms such as Windows and Linux etc.
 We can insert images, links and relative paths from the Workspace.
 Graphics ,videos and sounds can also be added to the web pages which give an extra
attractive look to your web pages.

2.2 Introduction To PHP

PHP (recursive acronym for PHP: Hypertext Preprocessor) is a widely-used open source general-
purpose scripting language that is especially suited for web development and can be embedded
into HTML. PHP is a server side scripting language that is embedded in HTML. It is used to
manage dynamic content, databases, session tracking, even build entire e-commerce sites. It is
integrated with a number of popular databases, including MySQL ,Oracle, Sybase and Microsoft
SQL Server.

 Common uses of PHP:

PHP can handle forms, i.e. gather data from files, save data to a file, thru email you can send
data, return data to the user.

You add, delete, modify elements within your database thru PHP.

2
Access cookies variables and set cookies.

Using PHP, you can restrict users to access some pages of your website.

 Usage

PHP is a general-purpose scripting language that is especially suited to server-sideweb

development where PHP generally runs on a web server. Any PHP code in a requested file is
executed by the PHP runtime, usually to create dynamic web page content or dynamic images
used on Web sites or elsewhere. It can also be used for command-line scripting and client-
sideGUI applications. PHP can be deployed on most Web servers, many operating systems and
platforms, and can be used with many relational database management systems (RDBMS). It is
available free of charge, and the PHP Group provides the complete source code for users to
build, customize and extend for their own use.

PHP acts primarily as a filter, taking input from a file or stream containing text and/or PHP
instructions and outputting another stream of data; most commonly the output will be HTML.
Since PHP 4, the PHP parsercompiles input to produce code for processing by the Zend Engine,
giving improved performance over its interpreter predecessor.

2.3 Introduction To CSS

Cascading Style Sheets, fondly referred to as CSS, is a simple design language intended to
simplify the process of making web pages presentable.CSS handles the look and feel part of a
web page. Using CSS, you can control the color of the text, the style of fonts, the spacing
between paragraphs, how columns are sized and laid out, what background images or colors are
used, layout designs ,variations in display for different devices and screen sizes as well as a
variety of other effects.

CSS is easy to learn and understand but it provides powerful control over the presentation of an
HTML document. Most commonly, CSS is combined with the markup languages HTML or
XHTML.

3
2.4 Introduction To jQuery
The purpose of jQuery is to make it much easier to use JavaScript on your website.jQuery is a
lightweight, "write less, do more", JavaScript library. The purpose of jQuery is to make it much
easier to use JavaScript on your website. jQuery takes a lot of common tasks that require many
lines of JavaScript code to accomplish, and wraps them into methods that you can call with a
single line of code. jQuery also simplifies a lot of the complicated things from JavaScript, like
AJAX calls and DOM manipulation.

2.5 Introduction ToJavascript

In spite of the similarity of names, JavaScript is not Java. The languages are not related. Java is
frequently used to program games, mobile phones, and other devices, such as the Amazon
Kindle. Although Java can be used in websites, it's rarely used that way.

JavaScript, on the other hand, is a lightweight, yet powerful language that normally runs inside a
web browser. Its role is to provide access to different elements of the page so that they can be
removed or updated. It can also create new elements, change the style of existing elements, or
extract information from them.

2.6 Introduction ToSQL

SQL (Structured Query Language) is a computer language used to store, manipulate, and retrieve
data stored in databases. The first manifestation of SQL appeared in 1974, when a group in IBM
developed the first sample of a relational database. The first commercial relational database was
released by Relational Software. Standards for SQL exist. However, the SQL that can be used on
each one of the major RDBMS today is in different flavors.

SQL is short for Structured Query Language and is a widely used database language, providing
means of data manipulation (store, retrieve, update, delete) and database creation.

Almost all modern Relational Database Management Systems like MS SQL Server, Microsoft
Access, MSDE, Oracle, DB2, Sybase, MySQL, Postgres and Informix use SQL as standard
database language.

4
 Chapter 3

Existing System

 Drawbacks of Existing System

 Slow response about Hotel
 Low quality customer service.
 High registration and service charge
 Time wastage

5
 Chapter 4
Proposed System

The aim of proposed system is to develop a system of improved facilities. The proposed system
can overcome all the limitations of the existing system. The system provides proper security and
reduces the manual work. The existing system has several disadvantages and many more
difficulties to work well. The proposed system tries to eliminate or reduce these difficulties up to
some extent. The proposed system will help the user to reduce the workload and mental conflict.
The proposed system helps the user to work user friendly and he can easily do his jobs without
time lagging. We want to make a digital india. All peoples can used credit cards,debit cards our
buy products for payment so that’s why we need to use online shopping not offline. This process
actually helps to connect every people to the internet.

 Expected Advantages of Proposed System

The system is very simple in design and to implement. The system requires very low system
resources and the system will work in almost all configurations. It has got following features

6
 Chapter 5

System Development Process

5.1. System Analysis

System analysis is a process of gathering and interpreting facts, diagnosing problems and the
information to recommend improvements on the system. It is a problem solving activity that
requires intensive communication between the system users and system developers. System
analysis or study is an important phase of any system development process. The system is
studied to the minutest detail and analyzed. The system analyst plays the role of the interrogator
and dwells deep into the working of the present system. The system is viewed as a whole and the
input to the system are identified. The outputs from the organizations are traced to the various
processes. System analysis is concerned with becoming aware of the problem, identifying the
relevant and decisional variables, analyzing and synthesizing the various factors and determining
an optimal or at least a satisfactory solution or program of action.

A detailed study of the process must be made by various techniques like interviews,
questionnaires etc. The data collected by these sources must be scrutinized to arrive to a
conclusion. The conclusion is an understanding of how the system functions. This system is
called the existing system. Now the existing system is subjected to close study and problem areas
are identified. The designer now functions as a problem solver and tries to sort out the
difficulties that the enterprise faces. The solutions are given as proposals. The proposal is then
weighed with the existing system analytically and the best one is selected. The proposal is
presented to the user for an endorsement by the user. The proposal is reviewed on user request
and suitable changes are made. This is loop that ends as soon as the user is satisfied with
proposal.

Preliminary study is the process of gathering and interpreting facts, using the information for
further studies on the system. Preliminary study is problem solving activity that requires
intensive communication between the system users and system developers. It does various
feasibility studies.

7
5.2. Feasibility Study

Feasibility study is made to see if the project on completion will serve the purpose of the
organization for the amount of work, effort and the time that spend on it. Feasibility study lets
the developer foresee the future of the project and the usefulness. A feasibility study of a system
proposal is according to its workability, which is the impact on the organization, ability to meet
their user needs and effective use of resources. Thus when a new application is proposed it
normally goes through a feasibility study before it is approved for development.

The document provide the feasibility of the project that is being designed and lists various areas
that were considered very carefully during the feasibility study of this project such as Technical,
Economic and Operational feasibilities.

The following are its types:

 Technical Feasibility
The system must be evaluated from the technical point of view first. The assessment of this
feasibility must be based on an outline design of the system requirement in the terms of input,
output, programs and procedures. Having identified an outline system, the investigation must go
on to suggest the type of equipment, required method developing the system, of running the
system once it has been designed.
Technical issues raised during the investigation are:
 Does the existing technology sufficient for the suggested one?
 Can the system expand if developed?
The project should be developed such that the necessary functions and performance are achieved
within the constraints. The project is developed within latest technology. Through the technology
may become obsolete after some period of time, due to the fact that never version of same
software supports older versions, the system may still be used. So there are minimal constraints
involved with this project. The system has been developed using Php the project is technically
feasible for development.

8
  Economic Feasibility
The developing system must be justified by cost and benefit. Criteria to ensure that effort is
concentrated on project, which will give best, return at the earliest. One of the factors, which
affect the development of a new system, is the cost it would require.
The following are some of the important financial questions asked during preliminary
investigation:
 The costs conduct a full system investigation.
 The cost of the hardware and software.
 The benefits in the form of reduced costs or fewer costly errors.
Since the system is developed as part of project work, there is no manual cost to spend for the
proposed system. Also all the resources are already available, it give an indication of the system
is economically possible for development.

 Behavioral Feasibility
This includes the following questions:
 Is there sufficient support for the users?
 Will the proposed system cause harm?
The project would be beneficial because it satisfies the objectives when developed and installed.
All behavioral aspects are considered carefully and conclude that the project is behaviorally
feasible.

9
 Chapter – 6

Design

Process design is the design of processes for desired physical and/or chemical transformation of
materials. Process design is central to chemical engineering, and it can be considered to be the
summit of that field, bringing together all of the field's components.

Process design can be the design of new facilities or it can be the modification or expansion of
existing facilities. The design starts at a conceptual level and ultimately ends in the form of
fabrication and construction plans.

6.1.1 Data Flow Diagram

The DFD’s represents the flow of the data among the different processes, entities and
records. Here are level-0 (context diagram) and 1 -level DFD’s. The level-0 DFD
represents the overall entities participating in the system excluding the detailed
functionality of the system. Whereas Level-1 DFD represents the module wise detailed
functionality-of-the-system.

DFDs: Diagrammatic elements:

A producer or consumer of information that resides outside

EXTERNAL
the bounds of the system to be modeled.
ENTITY

A transformation of information (a function) that resides

PROCESS
within the bounds of the system to be modeled.

A data object, the arrowhead indicates the direction data of

data flow.
DATA OBJECT

10
6.2 Project DFD

6.2.1 level-0 DFD

Online hotel

management All information regards

USER
system services

Figure:1.2: Level-0 DFD(User)

Level 1: For User Register

Register
User Register

Verify
Login

Figure: 1.3: Level-1 DFD(User Register)

11
Level-2 DFD:
Reservati-on
reservation

Menu

add-prduct

Add to cart

Order

Register User

Location location

Check-out

Payment Orderdetail

Orderdetail

Cancel order
Cancelord

12
6.2.2 level-0 DFD

Login
Admin
Admin

Figure:1.4: Level-0 DFD(Admin)

Level 1: For Admin

Add Add

Category Category

Add
Admin Add
Services
Services

Manage

Services
Manage

Services
Order

Order

Figure:1.5: Level-1 DFD(User)

13
6.2.3 Control Flow Diagram: For Admin

Start

Login

No yes

Add Add Sub Add

Location Category Category Product
Stop

Manage

Figure 1.6: Control Flow Diagram(Admin)

14
6.2.3 Control Flow Diagram: For User

Start

View Services

Add To Cart

Order

Yes Check No

Register

Login

Location

Order Now

Checkout

Payment

Stop

15
6.3 Data flow diagram

6.3.1 Level 0 for User

Airline All information

Reservation
USER Regarding

Services

6.3.2 Level 1 For User

Register

Register
User

Email/pwd verify

Login Service

Acess services

16
6.3.3 DFD of Admin: for Level 1

Add Products
Admin

See All Order Add Product

See Order

See Order

17
6.4 Database Design

A database is an organized mechanism that has the capability of storing information through
which a user can retrieve stored information in an effective and efficient manner. The data is the
purpose of any database and must be protected.

The database design is a two level process. In the first step, user requirements are gathered
together and a database is designed which will meet these requirements as clearly as possible.
This step is called Information Level Design and it is taken independent of any individual
DBMS.

In the second step, this Information level design is transferred into a design for the specific
DBMS that will be used to implement the system in question. This step is called Physical Level
Design, concerned with the characteristics of the specific DBMS that will be used. A database
design runs parallel with the system design. The organization of the data in the database is aimed
to achieve the following two major objectives:

 Data Integrity
 Data independence

Normalization is the process of decomposing the attributes in an application, which results in a

set of tables with very simple structure. The purpose of normalization is to make tables as simple
as possible. Normalization is carried out in this system for the following reasons.

 To structure the data so that there is no repetition of data , this helps in saving.

 To permit simple retrieval of data in response to query and report request.

 To simplify the maintenance of the data through updates, insertions, deletions.

 To reduce the need to restructure or reorganize data which new application

Requirements arise.

18
Relational Database Management System (RDBMS)

A relational model represents the database as a collection of relations. Each relation resembles a
table of values or file of records. In formal relational model terminology, a row is called a tuple,
a column header is called an attribute and the table is called a relation. A relational database
consists of a collection of tables, each of which is assigned a unique name. A row in a tale
represents a set of related values.

 Relations, Domains & Attributes:

A table is a relation. The rows in a table are called tulles. Tulle is an ordered set of n elements.
Columns are referred to as attributes. Relationships have been set between every table in the
database. This ensures both Referential and Entity Relationship Integrity. A domain D is a set of
atomic values. A common method of specifying a domain is to specify a data type from which
the data values forming the domain are drawn. It is also useful to specify a name for the domain
to help in interpreting its values. Every value in a relation is atomic, that is not decomposable.

Relationships:
Table relationships are established using Key. The two main keys of prime importance are
Primary Key & Foreign Key. Entity Integrity and Referential Integrity Relationships can be
established with these keys.

 Entity Integrity enforces that no Primary Key can have null values.
 Referential Integrity enforces that no Primary Key can have null values.
 Referential Integrity for each distinct Foreign Key value, there must exist a matching
Primary Key value in the same domain. Other key are Super Key and Candidate
Keys.
 Relationships have been set between every table in the database. This ensures both
Referential and Entity Relationship Integrity.

19
 Chapter 7

Software& Hardware Specifications

7.1 Software Requirements:-

Front End Tool : PHP

Web Server : Wamp Server

Back End Tool : MYSQL 5.6.12

Browser : Mozilla Firefox /Chrome etc

Operating System : Windows Operating System

To Developed : Notepad ++

7.2 Hardware Requirements:-

Processor : Intel(R)core(TM)i3-3120M

RAM : 512 MB or higher

Hard Disk : 80 GB or higher

20
 Chapter 8

Screen Shots

Screen-Shots of User Panel

Front page of project:

21
About page of project:

22
Payment: Select payment method cash or card.

23
Register: If you are new user for our site please register for booking flight and fill all
information.

24
Login: If you are existing user then click on login and enter your email address and
password.

25
Add to Cart

26
Order

27
CheckOut

28
Screen-Shots of Database:

Add Services

29
Register Table

30
Order Table

Chapter 9
31
 System Implementation and Testing

9.1 Implementation
Implementation is the status of the project when the theoretical designs turned into a working
system. It is the process of converting a new revised system in to an operational one. It is the key
stage in achieving a successful new system because usually it involves a lot of upheaval in the
use department. It must therefore carefully plan and controlled so as to avoid chaos.

Apart from planning, the two major task of preparing for implementation are education and
training of users and testing of system. Education of users should really have taken place much
earlier in the project when they were being involved in the investigation and design work.

The user staff has been given necessary training for using the system. The training has made
them to get acquainted with the system. The development any system results in success only
when the system is implemented properly.

9.2 Testing

Testing is one of the major hurdles in the development of the system. Testing is the process of
fining errors in the system. Only error-free website will be stable for a long time. There are
different types of techniques for finding the bugs in website.

System testing is the major quality control measure during software development. A series of test
cases are generated that is intended to demolish the software that has been built. Testing is a set
activity that can be planned and conducted schematically. Testing begins at the module level and
work towards the integration of entire computer based system.

Testing is a process of executing a program with the intention of finding an error. A good test
case is one that has a higher probability of finding an undiscovered error. A successful test case
is one that uncovers an undiscovered error. Nothing is complete without testing, as it the vital
success of the system.

 Testing Objectives

32
There are several rules that can serve as testing objectives. They are

 Testing is a process of executing a program with the intent of finding an error.

 A good test case is one that has high probability of finding an undiscovered error.

 A successful test is one that uncovers an undiscovered error.

If testing is conducted successfully according to the objectives as stated above, it would

uncover errors in the software. Generally by testing we are verifying the following three aspects.

 Testing for correctness

 Testing for implementation efficiency

Chapter 10

33
 Bibliography
 www.google.com

 www.financebusiness.com

 www.w3school.com

 www.scribd.com/pages?/emp

 www.php.net

 www.w3schools.in

 www.tutorialspoint.com

34