PROJECT FILE

“HOTEL MANAGEMENT system”

NAME: AARZOO
TYAGI
CLASS:12 A
ROLL NO.:
 CERTIFICATE

This is to certify that my student AARZOO TYAGI

Class XII of ROSARY SE.SEC.SCHOOL has

completed

project Aimed

“HOTEL MANAGEMENT SYSTEM”

under my guidance and supervision.

SIGNATURE(TEACHER)
 ACKNOWLEDGEMENT

“The satisfaction and Euphoria that accompany the successful completion of

any world of any would be but incomplete. The mention of the people who
made it possible, whose constant guidance and encouragement served as a
beacon light and crowned my efforts with success”.

I consider it a privilege to express through the pages of this report, a few

words of gratitude and respect to all those who guided and inspired in
completion of this project.

I am deeply indebted to our guide MRS.NIDHI SHINDEwhom by virtue of

this office constantly encouraged me and I tender my utmost guidance and
appreciation for his invaluable guidance and suggestions extended by him.

I wish to express my indebtedness to other of the organization for their help

and encouragement. Their untiring enthusiasm and zeal has always inspired
me in my project.

These are the words of relatively spoken and the entire above mentioned share
credit of my present achievement as well as in future.
 Contents / Index

➢ Introduction
➢ Objective ans Scope of the project
➢ Hardware and Software requirements
➢ Python Concepts and Overview
➢ Coding
➢ Outputs
➢ References / Bibliography
 Introduction
This software project is developed to automate the functanalities of a
HOTEL MANAGEMENT SYSTEM.
The purpose of the software project is to develop the management
information and to automate the record keeping of customers,
hotelrooms and staff.
It mainly consists of a computerized database, a collection of
interrelated tables, CSV files for a particular subject or. CSV files are
capable to produce different reports relevant to the user. An
application program is tied with the database for easy access and
interface to the database. Using PYTHON we can perform various
functions and we can alse store, retrieve and manage all information in
proper way. During coding and designingof the software project,
PYTHON IDLE is used as a powerful front-end tool for getting graphical
user interface (GUI) based integrated platform and coding simplicity.
And also, comma separated values file (CSV) is used as per
requirements of the CBSE curriculum of informatics practices course
(065).

CONTRIBUTION/TEAM MEMBERS:
PRATISHTHA SANPAL- CODING , EXCEL SHEET
AYUSH NEGI-DATA ANALYZING
AARZOO TYAGI-RESEARCH WORK

Objective of the project

The HOTEL MANAGEMENT SYSTEM will provide service to online
customers. Online customers can make searches, reservations and
cancel an existing reservation on the hotel’s website.
The objective of the software project is to develop a computerized
management system (MIS) and to automate the functions of a HOTEL
MANAGEMENT SYSTEM. This software project is also aimed to enhance
the current record keeping system, which will help managers to retrieve
the up-to-date information at right time in right shape.

This software system is providing the following functions:-

❖ These software systems maintains all the records of booking

and date of check in and check out and generate required
information wherever required.
❖ It provide a customer friendly envioronment for HOTEL
MANAGEMENT activities.
❖ Write programs utilizing modern software tools.
❖ Apply object oriented programming principles effectively when
developing small to medium sized projects.
❖ Write effective procedural code to solve small to medium sized
problems.
❖ Students will demonstrate a breadth of knowledge in
Informatics Practices, as exemplified in the areas of systems,
theory and software development.
❖ Students will demonstrate ability to conduct a research or
applied Informatics Practices project, requiring writing and
presentation skills which exemplify scholarly style in
Informatics Practices.

During the development of HOTEL MANAGEMENT SYSTEM project,

python IDLE, a powerful oper source module driven form-based
development environment is used for modular design and future
expandability of the system.

Scope of the project:-

The scope of this project is to facilitate easy management and

administration of a hotel with capabilities to do booking or reservations
of the rooms, cancellation of the rooms, creating of new user, room
service, and total biling etc. using the computerized hotel management
software. One can keep detailed records or info on an unlimited
amount of customers. The system lets the user know which all rooms
are available for occupancy at any point of time. This makes the
booking considerably faster. And thus heps the hotel in doing better
management and reduce a lot of paper work as well as manpower.

Hardwarwe and software requirements

Hardware requirements:-

• Manufacturer:-Lenovo

• System model:-81H7

• RAM:-4.00 GB

• Windows:-10

• Processor:-Intel® Core™ i3-7020U CPU @2.30Hz 2.30GHz

• System type:-64-bit Operating System, x64-based processor

Software requirements:-

• Windows 10:

• IDLE(Python 3.9 64-bit) :

Python concepts and overview

Python is an interpreted, high-level and general-purpose programming
language. Python's design philosophy emphasizes code readability with
its notable use of significant indentation. Its language constructs
and object-oriented approach aim to help programmers write clear,
logical code for small and large-scale projects.
Python was developed by Guido Van Rossum in 1991. Python is a
general-purpose language that can be used effectively to build any kind
of program that does not require direct access to the computer’s
hardware.
Python 2.0 was released in 2000 and introduced new features, such as
list comprehensions and a garbage collection system using reference
counting and was discontinued with version 2.7.18 in 2020. Python 3.0
was released in 2008 and was a major revision of the language that is
not completely backward-compatible and much Python 2 code does not
run unmodified on Python 3.Python consistently ranks as one of the
most popular programming languages.
Python is a flexible, dynamic and powerful language that can be used in
different ways. It can be interactively used simply to test a code or a
ststement line by line or while exploring its interface.python is used by
google seach engine , you tube, etc. it is being widely used for system
programming, GUI programming,web gaming, commercial robots, etc.

Features of python
• Free and open source: it is an open source and portable language
having a large repository of libraries .It is an open source means
that its source code is available to the public.

• Interpreted language: python is an interpreted, inactive, directly

executed language with a pre compiled code. This means that it is
processed ar runtime by the interpreter and you need not to
compile yopur program while executing it.

• It supports GUI (graphical user interface) and garbage collection

(better memory management system).

• It is easily compatible with other languages like c++, core java etc.

• It takes less time to develop as python programs are typically 3-5

times shorter than the equivalent java programs. This is because
of its built-in, high level data types and its dynamic typing.
 Csv files
• Book1

• Restaurant
 Coding
# HOTEL MANAGEMENT SYSTEM

import pandas as pd import

matplotlib.pyplot as plt
from tabulate import tabulate

print('**********************WELCOME TO HOTEL MANAGEMENT

SYSTEM**********************\n\n')

flag=True

while(flag):
print('<<<<<<<<<<<<<<<<<<<<<<SELECT THE OPTION AS PER YOUR
REQUIREMENT>>>>>>>>>>>>>>>>>>\n') print('PRESS 1 TO INSERT NEW
RECORD') print('PRESS 2 TO VIEW ALL THE RECORDS') print('PRESS 3 TO
SEARCH A RECORD BY BOOKING ID') print('PRESS 4 TO SEARCH A RECORD BY
CUSTOMER NAME') print('PRESS 5 TO SEARCH A RECORD BY ROOM NO')
print('PRESS 6 TO SEARCH A RECORD BY CHECK IN') print('PRESS 7 TO SEARCH
A RECORD BY CHECK OUT') print('PRESS 8 TO SEARCH A RECORD BY PHONE
NO') print('press 9 TO SHOW MENU OF RESTAURENT') print('PRESS 10 TO
CALCULATE TOTAL FOOD BILL') print('PRESS 11 TO MAKE GRAPH BETWEEN
FOODITEMS AND THEIR RATES') print('PRESS 12 TO MAKE GRAPH BETWEEN
ROOM NO AND NO OF MEMBERS')
print('PRESS 13 TO DELETE THE RECORD')
print('PRESS ANY OTHER NUMBER TO QUIT\n')
choice=int(input('ENTER YOUR CHOICE:::***>>'))

#to insert new record

if choice==1:
id=input('ENTER BOOKING ID::')
name=input('ENTER CUSTOMER NAME::')
members=int(input('ENTER NO OF MEMBERS::'))
rno=int(input('ENTER ROOM NO::'))
rtype=input('ENTER ROOM TYPE::')
bookingdate=input('ENTER BOOKING DATE::')
checkin=input('ENTER CHECK IN::')
checkout=input('ENTER CHECK OUT::')
rs=int(input('ENTER PRICE::'))
phoneno=int(input('ENTER PHONE NO::'))
l=[[id,name,members,rno,rtype,bookingdate,checkin,checkout,rs,phoneno]]
df=pd.DataFrame(l)

df.to_csv("E:\\book1.CSV",mode='a',header=False,index=False)

print('RECORD INSERTED SUCCESSFULLY')

print('Now the data in the file is:::')
df1=pd.read_csv("E:\\book1.CSV")
pd.set_option('display.max_columns',None) print(df1)
print(tabulate(df,headers='keys',tablefmt='psql'))
 #to view all records
elif choice==2:
df=pd.read_csv("E:\\book1.CSV")
pd.set_option('display.max_columns',None) print(df)
print(tabulate(df,headers='keys',tablefmt='psql'))

#to search a record by booking id

elif choice==3:
n=input('ENTER THE BOOKING ID TO SEARCH:::***>>>')

df=pd.read_csv("E:\\book1.CSV",names=['BOOKING ID','CUSTOMER NAME','NO OF

MEMBER','ROOM NO','ROOM TYPE','BOOKING DATE','CHECKIN','CHECKOUT','PRICE','PHONE NO'])

Val=df[df['BOOKING ID']==n]
pd.set_option('display.max_columns',None)
print(tabulate(Val,headers='keys',tablefmt='psql'))

if(Val.empty==True): print('NO
SUCH CUSTOMER Exists') else:
print(Val)

#to search a record by customer name

elif choice==4:
n=input('ENTER THE CUSTOMER NAME TO SEARCH:::**>>')

df=pd.read_csv("E:\\book1.CSV")

Val=df[df['CUSTOMERNAME']==n]
pd.set_option('display.max_columns',None)
print(tabulate(Val,headers='keys',tablefmt='psql'))

if(Val.empty==True):
print('NO SUCH CUSTOMER Exists')
else:
print(Val)

#to search a record by room no

elif choice==5:
n=input('ENTER THE ROOM NO TO SEARCH:::**>>')

df=pd.read_csv("E:\\book1.CSV")

Val=df[df['ROOMNO']==n]
pd.set_option('display.max_columns',None)
print(tabulate(Val,headers='keys',tablefmt='psql'))
if(Val.empty==True): print('NO SUCH CUSTOMER Exists') else:
print(Val)
#to search a record by check in
elif choice==6:
n=input('ENTER THE CHECK IN TO SEARCH:::**>>')

df=pd.read_csv("E:\\book1.CSV")

Val=df[df['CHECKIN']==n]
pd.set_option('display.max_columns',None)
print(tabulate(Val,headers='keys',tablefmt='psql'))

if(Val.empty==True): print('NO
SUCH CUSTOMER Exists') else:
print(Val)

#to search a record by check out

elif choice==7:
n=input('ENTER THE CHECK OUT TO SEARCH:::**>>')

df=pd.read_csv("E:\\book1.CSV")

Val=df[df['CHECKOUT']==n]
pd.set_option('display.max_columns',None)
print(tabulate(Val,headers='keys',tablefmt='psql'))

if(Val.empty==True):
print('NO SUCH CUSTOMER Exists')
else: print(Val)

#to search a record by phone no

elif choice==8:
n=input('ENTER THE PHONE NO TO SEARCH:::**>>')

df=pd.read_csv("E:\\book1.CSV")

Val=df[df['PHONENO']==n]
pd.set_option('display.max_columns',None)
print(tabulate(Val,headers='keys',tablefmt='psql'))

if(Val.empty==True): print('NO
SUCH CUSTOMER Exists') else:
print(Val)

#to show menu of restaurent

elif choice==9:
print('SHOW MENU OF RESTAURENT')
print()
 df=pd.read_csv("E:\\Restaurent.csv")
print(df)

#to calculate total bill of restaurent

elif choice==10:
df=pd.read_csv("E:\\Restaurent.csv",names=["SNO","FOODITEMS","RATE"])
print(df)
RATE={"coffee":85,"soups":95,"juices":50,"tacos":100,"dinner_plate":150}
print("restaurent bill calculator\n") print("enter the quality of ordered
item:\n") coffee=int(input("coffee::")) soups=int(input("soups::"))
juices=int(input("juices::")) tacos=int(input("tacos::"))
dinner_plate=int(input("dinner_plate::"))

cost=coffee*RATE["coffee"]+soups*RATE["soups"]+juices*RATE["juices"]+tacos*RATE["tacos"]+dinner_
plate*RATE["dinner_plate"]
tax=0.8
bill=cost+cost*tax
print("please pay rs %f" %bill)

#to make a graph between fooditems and rate

elif choice==11: df=pd.read_csv("E:\\
Restaurent.csv") x=df['FOODITEMS']
y=df['RATE']
plt.barh(x,y,color='yellow',edgecolor='black')
plt.xlabel('RATE') plt.ylabel('FOODITEMS')
plt.title('FOODITEMS AND THEIR RATE')
plt.show()

#to make a graph between room no nad no of members

elif choice==12: df=pd.read_csv("E:\\book1.CSV")
x=df['ROOMNO'] y=df['NOOFMEMBERS']
plt.plot(x,y,color='purple',linewidth=4,linestyle='dashed')
plt.title("GRAPH BETWEEN ROOM NO AND NO OF MEMBERS")
plt.xlabel("ROOMNO")
plt.ylabel("NOOFMEMBERS")
plt.show()

#to delete the record and to quit

elif choice==13:
n=input('ENTER THE BOOKING ID TO DELETE:::**>>')

df=pd.read_csv("E:\\book1.CSV",names=['BOOKING ID','CUSTOMER NAME','NO OF

MEMBER','ROOMNO','ROOM TYPE','BOOKING DATE','CHECKIN','CHECKOUT','PRICE','PHONE NO'])
 Val=df[df['BOOKING ID']==n]

if(Val.empty==True): print('NO
SUCH CUSTOMER Exists') else:
ind=df[df['BOOKING ID']==n].index.values
df=df.drop(ind,axis=0)
df.to_csv("E:\\book1.CSV",header=False,index=False)
print('Record deleted successfully') else:
print('THANKS FOR USING OUR SERVICES!!!')
print('===========************============')
flag=False

OUTPUT
References and Bibliography

➢ Informatics Practices with python by Sumita arora

➢ Informatics Practices with python by Preeti arora

➢ http://xiipython.blogspot.com/

➢ http://www.greeksforgreeks.org/