I. INTRODUCTION

Hotel Management software package can be readily used by non-programming personal avoiding human handled chance of error. This project is used by two types of users:

i. Online Users.

ii. Administrator (management of the Hotel).

Administrator can maintain daily updates in the hotel records. Administrator is must be an authorized user. He can further change the password. There is the facility for password recovery, logout etc.

The main aim of the entire activity is to automate the process of day to day activities of Hotel like Room activities, Admission of a New Customer, Assign a room according to customer’s demand, checkout of a computer and releasing the room and finally compute the bill etc.

The limited time and resources have restricted us to incorporate, in this project, only main activities that are performed in a HOTEL Management System, but utmost care has been taken to make the system efficient and user friendly. “HOTEL Management System” has been designed to computerize the following functions that are performed by the system:

ü Room Detail Functions

o Opening a New Room

o Modification to room assigned

ü Check-in and check-out Detail Functions

o Admission of New customer

o Check-out of customer

o Room assigning related to customer’s need.

ü Statement of Customer Details

o Check-in customer

o Check-out customer

o Room Details

ü Total number of Customers in the Hotel

o Individual customer Report

II. OBJECTIVE

During the past several decades’ personnel function has been transformed from a relatively obscure record keeping staff-to-central and top level management function. There are many factors that have influenced this transformation like technological advances, professionalism, and general recognition of human beings as most important resources.

A computer based management system is designed to handle all the primary information required to calculate monthly statements. Separate database is maintained to handle all the details required for the correct statement calculation and generation.

The searching of record has been made quite simple as all the details of the customer can be obtained by simply keying in the identification of that customer.

Also for record maintenance and updation can also be accomplished by using the identification of the customer with all the details being automatically generated. These details are also being promptly automatically updated in the master file thus keeping the record absolutely up-to-date.

The entire information has maintained in the database or Files and whoever wants to retrieve can’t retrieve, only authorization user can retrieve the necessary information which can be easily be accessible from the file.

The main objective of the entire activity is to automate the process of day to day activities of Hotel like:

ü Room activities,

ü Admission of a New Customer,

ü Assign a room according to customer’s demand,

ü Checkout of a computer and releasing the room

ü Finally compute the bill etc.

ü Packages available.

ü Advance online bookings.

ü Online Cancellation.

ü List of Regular customers.

ü Email facility.

ü Feedbacks

This project has some more features:

• System Connectivity

• No data duplication

• No Paper Work Required

• Time Efficient

• Cost Efficient

• Automatic data validation

• User friendly environment

• Data security and reliability

• Fast data insertion & retrieval

• Easy performance check

III. ADVANTAGE:

We have design the given proposed system in the JSP to automate the process of Hotels. This project is useful for the authorities which keep track of all the users registered in a particular state .The authority can add hotel packages, room details, availability of rooms, online booking etc.

The following steps that give the detailed information of the need of proposed system are:

Performance: During past several decades, the records are supposed to be manually handled for all activities. The manual handling of the record is time consuming and highly prone to error. To improve the performance of the Hotel Management System, the computerized system is to be undertaken. This project is fully computerized and user friendly even that any of the members can see the report and status of the company.

Efficiency: The basic need of this website is efficiency. The website should be efficient so that whenever a new user submits his/her details the website is updated automatically. This record will be useful for other users instantly.

Control: The complete control of the project is under the hands of authorized person who has the password to access this project and illegal access is not supposed to deal with. All the control is under the administrator and the other members have the rights to just see the records not to change any transaction or entry.

Security: Security is the main criteria for the proposed system. Since illegal access may corrupt the database. So security has to be given in this project.

IV. SYSTEM ANALYSIS

A. ENTITY RELATIONSHIP DIAGRAM (ERD)

Entity – Relationship Diagram: This depicts relationship between data objects. The attribute of each data objects noted in the entity- relationship diagram can be described using a data object description. Data flow diagram serves two purposes:

1. To provide an indication of how data are transformed as they move through the system.

2. To depict the functions that transformation the data flow.

Data Objects: A data object is a representation of almost any composite information that must be understood by the software. By composite information, we mean something that has a number of different properties or attributes. A data object encapsulates data only there is no reference within a data object to operations that act on the data.

Attributes: Attributes define the properties of a data object and take on one of three different characteristics. They can be used to:

1. Name an instance of data object. Describe the instance.

2. Make reference to another instance in other table.

Relationships: Data objects are connected to one another in a variety of different ways. We can define a set of object relationship pairs that define the relevant relationships.

B. Various Model of E-R Diagram for Hotel online Management System, which are describe below:

1. Basic E-R Diagram: