Hotel management-system-hms

A Project report
On
HOTEL MANAGEMENT SYSTEM
Miran Muhammad Hussen
IT support

Introduction
• Hotels are the place where you stay, eat meals and utilize their other
services.
• As computer has merged with man as single entity so a computerized
application can be developed that can handle Hotel Management System
(HMS).
• Various activities takes place in hotel like:-
• Hotel needs to maintain the record of guests and reserve rooms beforehand.
• Customers should be able to know the availability of the rooms on a
particular date.
• They should be able to reserve the available rooms according to their need in
advance.
• To make their stay comfortable, they are provided with food and other
services.
• The record of the food taken by each customer and the services availed by
the customer should be kept.
• These records help in generating bill.
• All the above activity takes place manually, manually carrying out this
activity in very tedious time consuming.
• As we have tried to develop computerized application so as to handle all the
activity that takes place in Hotel.
• As all the activities that happen in the Hotel such as enquiry, check status
booking, food order etc. can be handled on this system simultaneously.

Existing System
The existing system of Hotel Management was manual. All the daily routines is
carried out manually and the records are maintained in the record books or the
registers.
Booking:-
The customer used to make enquiry for rooms available, and then depending
upon the status he used to make booking. All the data the receptionist used to give
the customer was based on paper works, there was no clear idea of the status of
rooms as they did not update automatically.
Food Order:-
The customer gives the food order to the waiter, and then the waiter pass that
order to the food department.
Bill Generation:-
The clerk operates the bill department he used to generate the bill of the
customer depending upon the services utilized by the customer.
Inventory:-
The inventory manager manages the inventory as he checks the status of the
inventory and as per that he order places the order.
Report:-
The administrator views all the report of the various departments, to check
the progress of the hotel and to make the necessary changes.

Limitations of Existing System
• Lots of paperwork is involved and it is difficult to handle and maintain such
a large amount of data.
• Manual activities are very time consuming and a tedious job.
• It is very difficult to retrieve any particular data.
• Changes are difficult to make.
• A very large amount of data redundancy occurs
• If any changes have taken in case of room status then the changes has to be
reflected on the desk of the receptionist.
• But these changes are not generated automatically but it has to be passed by
the room service to the clerk.
• Report generation is not an easy task and the accuracy of the reports
generated cannot be guaranteed

Need for Proposed System
• Previously the management work was done manually.
• It was a tedious job and also time consuming.
• Therefore it was need to develop a computerized system which will reduce
the job complexity, improve efficiency and should be economically feasible.

Goals
• To increase the effectiveness of the management.
• Generation of the reports should be easy, up to date and flawless.
• Reduce human errors and easy maintenance of the database.
•
Objectives
• This system provides the idea to the management about present condition
and also supports management decision making system.
• The objective of our system is to eliminate the chances of error that will
occur in manually handling the system.
• This system will minimize the paper work and reduces the work time and
complexity of the user.
• By using this system the data will be stored in organized manner.
• The system has GUI interface, so it is very user friendly

Statement of Scope
Booking:-
Customers come for an enquiry our system will give the updated status of
the room, and it will help the customers to choose the room from the available,
it will also provide the facility of pre- booking.
Food Order:-
When customer gives the food order, a note is generated of the customer
food order and it is been send to the food department.
Bill Generation:-
The clerk here generates the bill of the customer, the clerk will get all the
information automatically on his system regarding the customer service utilities
and on that base he will generate the bill.
Inventory:-
The inventory manager will get the status of the inventory automatically on
his system, and based on that he will manage the inventory.
Reports:-
One of the key features of the system is that it will generate the report of all
the departments.

USE CASE DIAGRAM-Hotel Management System
Room Book
Table Book
Receptionist
Manage Tours
Clerk
Bill Generation
Service Person
Food Orders
Accept Orders
Place Orders
Inventory Manager
Update Inventory
Generate Report
Manager
Registration
Login

ACTIVITY DIAGRAM-Booking
START
RECEPTIONIST SYSTEM CUSTOMER
Registration
Login
Check Status
Confirm
Booking
Customer Give
Details
available
validation
new
yes
no
Enquiry For
Booking
no
yes
yes
no
stop

ACTIVITY DIAGRAM-Food Order
Registration
Service Person
Login
Start
Yes
No
registration
System
Stop
Customer
Gives Food
OrderNew

ACTIVITY DIAGRAM-Tours
Customer Receptionist Cab Agency
Request For
Cab
Order For Cab Check
Availability
available
Send Cab
Manage Tour
Details
Get Cab
start
stop
yes
no

ACTIVITY DIAGRAM-Inventory Management
Inventory Manager System Supplier
Start
New registration
login Check inventory
system
Less
NoPlace Order
Yes
Accept Order
Supply Order
Received
Order
Update
Inventory
STOP

ACTIVITY DIAGRAM-Bill Generation
Clerk System
login
registration
Access Details
From All DEPT.
Generate
Reports
Print Bill
new
yes
no

ACTIVITY DIAGRAM-Reports
Clerk System
login
registration
Access Details
From All DEPT.
Generate
Reports
Print Bill
new
yes
no

CLASS DIAGRAM-Hotel Management System
Room Table
Customer
Clerks
offer do
has
generate pays
Inventory Inventorys Manager Orderhas
manage by place
manager
report
generate
checks
receptionist
Booking
confirm
Hotel
offer food
Bill

Sequence Diagram For-Login
: clerk : login form : login controller : Employee database
get id and password
receive id and password
validate id and password
send id and password
login successful
login successful
login successful

Sequence diagram for-Booking
: customer : Receptionist : Booking Form : Booking controller : customer database
gives personal details
fiils customer details
receive customer details
validate details
send customer details
successful booking
successful booking
successful booking
successfull booking

Sequence diagram for-Bill Payment
: Clerk : bill_form : bill_controller : customer_Database
fills customer details
receive customer details validate customer details
send customer details
return payment detailsreturn payment details
return payment details
return payment details

Sequence diagram for-Inventory
: manager :Inventory : control : database : supplier: inventory form
request inventory avail
request inventory
request
inventory details
inventory details
inventory details
validate details
inventory order to supplier
Supply goods
pay bill to supplier update database
update database
update msg sent
update msg sent
update msg sent

Collaboration diagram for-Login
: clerk : login form
: login controller : Employee database
3:
1:
7:
2:
6:
4:
5:

Collaboration diagram for-Booking
: customer : Receptionist : Booking Form
: Booking controller : customer database
1: 2:
3:
4:
5:
6:
7:
8:9:

Collaboration diagram for-Bill Payment
: Clerk : bill_form
: bill_controller : customer_Database
1:
2:
3:
4:
5:
6:
7:

Collaboration diagram for-Inventory
: manager :Inventory : control : database
: supplier : inventory form
1:
2:
3:
4:
5:
6:
7:
8:9:
10: 11:
12:
13:
14:

TEST CASE - Hotel Management System
Objective: Check whether the entered Login ID and Password are valid or invalid.
(Form LOGIN)
Sr.No Steps Data Expected Result Actual Result Status
1. Enter Login Id
and Password,
Press Login
Button
Login Id=’reception’
Password=’reception’
Should
Navigates to
main forms
Display main
forms
Approved
2. Enter Login ID
and Press Login
Button
Login Id=’’reception’’
Password=’ ‘
Should Display
Message Box
“Login Failed”
Message Box
appeared as
“Login Failed”
Approved
3. Enter Password
and Press Login
Button
Login Id=
Password=’XYZ123’
Should Display
Message Box
“Login Failed”
Message Box
appeared as
“Login Failed”
Approved
4. Enter Blank
Login ID and
Password, Press
Login Button
Login Id=
Password=’ ‘
Should Display
Message Box
“Login Failed”
Message Box
appeared as
“Login Failed”
Approved
5. Enter Wrong
Login ID and
Password, Press
Login Button
Login Id= “Rection”
Password=”gkdsgj556”
Should Display
Message Box
“Login Failed”
Message Box
appeared as
“Login Failed”
Approved

Objective: Check whether the entered details of Customer are in correct form or
not.(Form ROOM BOOKING & TABLE BOOKING)
Sr.No Steps Data Expected
Result
Actual Result Status
1. Enter name,
address,
contact_no,
email-id, room
type, no.of
guests, arrival
day & time &
departure date
and time
name=’Amit Mulay’
address =’Salisbury
Park’,pune’
no.of guests =’4’
room =’Deluxe’
arrival time =11:00
Am, arrival _day
=4/4/12,
contact_no=987689
0878
Should display
“Record Save
Successfully”
displays
“Book Record
Save
Successfully”
Approved
2. Enter the name
and press
Search button
name =’Amit
Mulay’
Should display
Record
displays
Record
Approved
3. Enter name,
address,
contact_no,
email-id,table
type, no.of
name=’Sagar
Khandagale’
address =’Market
Yard,Park’,pune’
Should display
“Record Save
Successfully
displays “Book
Record Save
Successfully
Approved

guests, arrival
day & time &
departure date
and time
no.of guests =’4’
table =’family ’
arrival time =09:00
Pm, arrival _day
=4/4/12,
contact_no=956189
0878
4. Enter the name
and press
Search button
name =’Ajit Kamble’ Should Display
Message Box
“Record Not
Found”
“Record Not
Found”
Approved
Objective: To check whether the entered details of Inventory are in correct form
or not.(Form Inventory)

Sr.No
Steps Data Expected
Result
Actual
Result
Status
1. Enter date,
Invoice_no,
Type,
supplier,
Rate,
particular,
issue_date,
Quantity_issue
d
date=21/3/12
Invoice_no=479,
Department=’Electronics’
Supplier=”Ajit Traders”,
Rate=5000/,
Particular=’dining table’,
issue_date=”2/4/12”,
Quantity_issued =’4’,
Should
display “
Record
Added
Successfully
”
displays “
Record
Added
Successfully
”
2. Enter date,
Invoice_no,
Type,
supplier,
Rate,
particular,
issue_date,
Quantity_issue
d
date=’’
Invoice_no=’’,
Department=’Electronics’
Supplier=””,
Rate=5000/,
Particular=’dining table’,
issue_date=”2/4/12”,
Quantity_issued =’4’,
Should
display
“Insert the
data in all
fields”
“Insert the
data in all
fields”
Approved
TEST PLAN-Hotel Management System

A Software Test Plan is a document describing the testing scope and activities. It is the basis for
formally testing any software/product in a project.
1. Test Plan Identifier
Hotel Management System.
2. Reference
a. Documents related to project.
b. SRS Documents
3. Introduction
a. Purpose of the Test Plan
The purpose of the test plan is to test the Hotel Management System
The system is being tested to avoid any kind of future defects when the
system will be delivered to the customer
Testing is one the standard procedure which is one of the important step in
system development
Testing determine the correctness of the software, and the correct
functionality performed by the software.
b. Scope of the Plan
The scope of the plan is to test all the module of the system such as
booking of room & table, inventory management, bill generation, report
generation.

c. Effects of Testing On Analysis
Once the testing is going on the developer will come to know that how
good their analysis was and they may also change their analysis based
on the success and failure of their testing.
4. Test Items(Functions)
Here we will describe that what actually has to be test in the test plan with respect
to the system
a. Booking
The booking function will be tested, the customer comes and request for the
booking of room and table as this is one of the important function of this system,
as it is a part of your system with which the customer will interact, it will be seen
that the customer details are entered correctly validation are done properly,
booking status is shown properly and the customer are well informed.
b. Food Order
This function is the internal part of the hotel system as it will be used only by the
employee of the hotel, this function will be checked to see that the customer gives
the food order and the order is taken properly as the time factor is important in
this in this function for the delivery of the order.

c. Inventory Management
Inventory management is also the internal part of the system as it is handled by
the inventory manager, this function is checked to see the inflow and outflow o
the data to check the product level, to give the status of the inventory
d. Bill Generation
The Clerk handles this function as he generates the bill for the customer.
This function will be tested to see that the when the bill is generated data related
to the bill comes properly to the clerk when then data is process the bill is
generated properly
e. Reports
As the admin dept. handle this function, to check the reports of all the
departments, this will be checked so as to see that when the reports are generated
all the data of the related department comes to the admin properly so that the
report generated are accurate
5. Software Risk Issue
In this there is need to be identified which software is to be tested and what the
critical areas of the software
a. What is the complex issue of the software?
b. Complex functionality of the software
c. What strategy to apply when some changes are suggested?
d. Past testing result
e. Repeatedly occurring error
f. Multiple Interface problem
g. Issues related to safety

6. Features to be Tested
Refer to section 4.
7. Features not to be Tested
-
8. Approach (Strategy)
Checked
following
Quality
parameter
Following Type of
Testing will be performed
on it
Following Method is
used for testing
Correctness Unit Testing White Box
Ease of use Usability Testing Black Box
Performance Performance Testing Black Box
Recover Testing

8. Suspension Criteria
Know when to pause in a series of step
If there is a particular defects arise again and again, and when the testing comes to a
point where we come to know that there is no need of going further for any kind of
testing the testing id suspended
For Ex.
When there is testing going on for booking of room and when the data do not enter in the
database as there may be some failure due to the validation then the testing will be
stopped and the validation criteria will be fixed again.
9. Test Deliverables
a. Diagrams
b. Screens Prototype
c. Analysis Document
d. Reports
10. Remaining Test Task

11. Environmental Needs
12. Staff And Training Needs
The staff needs to be trained to handle this system
Here the staff will be
Receptionist:
The receptionist will handle the booking of the customer as he/she should
be aware of the booking function.
Inventory Manager:
The Inventory Manager will handle the Inventory function of the system
and Inv. Manager must be trained to handle the system.
Clerk:
The clerk will handle the function of how to generate the bill and the clerk
must be trained to handle the system.
Task Assigned To
Create Acceptance Plan Test Manager, Project Manager, Client
Create System Integration Test Plan Test Manager , Project Manager ,
Development Team
Define Unit Test rules and Procedures Test Manager , Project Manager ,
Development Team
Verify prototypes of Screens Development Team, Client, Test Manager
Verify prototypes of Reports Development Team, Client, Test Manager

Manager:
The manager will handle the function of how to generate the report and
the manager must be trained to handle the system
The entire staff should be given the training of how to handle the system,
and they must be made aware of the function present in the system so that
they make optimum utilization of the system
13. Responsibility
The Responsibilities of various person involved in the project are given below
Test
Manager
Project
Manager
Development
Team
Test Team Client
Acceptance test
Documentation & Execution
X X X X
Unit test documentation &
execution
X X X
System Design Reviews X X X X
Detail Design Reviews X X X X X
Test procedures and rules X X X X
Screen & Report prototype
reviews
X X X
Change Control and
regression testing
X X X X
14. Schedule
Sr Event Date Budget

no
1 Introduction of the HMS
System
1/4/2012
2 Training on the
automated testing
Software which are used in
testing
24/4/2012 - 28/4/2012
3 Testing of System on Site 2/5/2012
4 System goes Live 10/6/2012
15. Approvals
Approved By Approved(Y/N)
Project Sponsor
Development Management
Test Manager
Project Manager
Client

Hotel management-system-hms

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Similar to Hotel management-system-hms

Similar to Hotel management-system-hms (20)

Recently uploaded

Recently uploaded (20)

Hotel management-system-hms