VELAMMAL VIDHYASHRAM

SURAPET

COMPUTER SCIENCE

Topic: HOTEL RESERVATION MANAGEMENT

Academic year: 2022-2023

DONE BY:

POOJA.K.G.M

XII-A1

1
 BONAFIDE CERTIFICATE

This is to certify that this COMPUTER SCIENCE Project on the topic

“HOTEL RESERVATION MANAGEMENT” has been successfully completed

by POOJA.K.G.M of class XII A1, [Link]……………at Velammal Vidhyashram,

Surapet, for the partial fulfillment of this project as a part of

Senior Secondary Certificate Examination-CBSE, New Delhi for the

academic Year 2022- 2023.

DATE: …………….

Signature of Principal Teacher incharge

Signature of the Signature of the

Internal Examiner External Examiner

2
 ACKNOWLEDGEMENT

Apart from the efforts of me, the success of any project depends largely
on the encouragement and guidelines of many others. I take this
opportunity to express my gratitude to the people who have been
instrumental in the successful completion of this project.

I express deep sense of gratitude to almighty God for giving me strength

for the successful completion of the project.

I express my heartfelt gratitude to my parents for constant

encouragement while carrying out this project.

I gratefully acknowledge the contribution of the individuals who

contributed in bringing this project up to this level, who continues to look
after me despite my flaws.

I express my deep sense of gratitude to the luminary The Director,

Principal, Bharathi Wing,Velammal Vidhyashram Surapet who has been
continuously motivating and extending their helping hand to us.

I express my sincere thanks to the CEO. Mr. VelMurugan, Velammal

Vidhyashram Surapet, for providing these opportunities in doing this
project.

My sincere thanks to [Link].K, Teacher In-charge, A guide, Mentor

all the above a friend, who critically reviewed my project and helped in
solving each and every problem, occurred during implementation of the
project.

The guidance and support received from all the members who
contributed and who are contributing to this project, was vital for the
success of the project.

I am grateful for their constant support and help.

3
 TABLE OF CONTENT

SNO TOPIC PAGE NO

01 ABSTRACT 5

02 SYSTEM CONFIGURATION 6

03 INTRODUCTION 7

04 OBJECTIVES OF THE PROJECT 7

05 PROPOSED SYSTEM 8

06 LIBRARIES AND FUNCTIONS USED 9

07 MYSQL QUERIES USED IN THE PROJECT 10

08 SOURCE CODE 11

09 OUTPUT (SCREENSHOTS) 21

10 CONCLUSION 28

11 BIBLIOGRAPHY 28

4
 ABSTRACT

The main objective of this program is to help the travelers to get the

complete information about room booking with all the required details.

This booking can be done through online. This is a desktop based program

where the management of entire hotel is customized. The hotel

management system is using python as front end and Mysql server as the

secured backend database. The ultimate motto of this project is to help the

travelers to get all the information about room prices, room’s availability,

food, laundry, games and other necessary information for room booking.

This project helps the users to carry this task online easily.

5
 SYSTEM CONFIGURATION

HARDWARE CONFIGURATION

Microsoft windows 7 professional/windows 8/windows 8.2:

 Processor : Intel Core i3 or equivalent

 Memory : 2 GB (32-bit), 4 GB (64-bit)
 Disk space : 1.5 GB of free disk space

SOFTWARE REQUIREMENTS
 1 GB RAM (2 GB+ recommended)
 9-58 GB free hard disk space depending on edition and
configuration, including space required for temporary files
 DVD-ROM drive (if installing from a Media Kit DVD)
 Basic GPU – Any vendor DirectX 9.0 class or better (Pixel Shader
Level 2)
 Intel® Pentium® or compatible, 1.6 GHz minimum (2GHz+
recommended)
 1024x768 or higher-resolution monitor

 MOUSE OR OTHER POINTING DEVICE

6
INTRODUCTION:
This Project on Hotel Reservation Management is a general software
developed (using python and mysql ) to simplify hotel operations by
automating them. In this Project “Hotel Taj” is the project’s hotel name. It
covers the major aspects of hotel management, it could perform the
following operations- Hotel room booking, provide the details of the hotel
rooms, informing about the food availability, Laundry and Billing.

OBJECTIVE OF THE PROJECT:

The objective of this project is to let the students apply the programming
knowledge into a real- world situation/problem and exposed the students
how programming skills helps in developing a good software.

1. Write programs utilizing modern software tools.

2. Apply object oriented programming principles effectively when

developing small to medium sized projects.

3. Write effective procedural code to solve small to medium sized

problems.
4. Students will demonstrate a breadth of knowledge in computer

science, as exemplified in the areas of systems, theory and software

development.
5. Students will demonstrate ability to conduct a research or applied

Computer Science project, requiring writing and presentation skills

which exemplify scholarly style in computer science.

7
PROPOSED SYSTEM

Today one cannot afford to rely on the fallible human beings of be

really wants to stand against today’s merciless competition where not to
wise saying “to err is human” no longer valid, it’s outdated to rationalize
your mistake. So, to keep pace with time, to bring about the best result
without malfunctioning and greater efficiency so to replace the unending
heaps of flies with a much sophisticated hard disk of the computer.

One has to use the data management software. Software has been
an ascent in atomization of various organizations. Many software
products working are now in markets, which have helped making the
organizations work easier and efficiently. Data management initially had
to maintain a lot of ledgers and a lot of paperwork has to be done but
now software product on this organization has made their work faster
and easier. Now only this software has to be loaded on the computer and
work can be done. This prevents a lot of time and money. The work
becomes fully automated and any information regarding the organization
can be obtained by clicking the button. Moreover, now it’s an age of
computers of and automating such an organization gives the better look.

8
LIBRARIES AND FUNCTIONS USED:

1. mysqlconnector - MySQL Connector/Python enables Python programs

to access MySQL databases, using an API that is compliant with the
Python Database API Specification v2.0 (PEP 249). It is written in pure
Python and does not have any dependencies except for the Python
Standard Library.
2. random- The random module is a built-in module to generate the
pseudo-random variables. It can be used perform some action
randomly such as to get a random number, selecting a random
elements from a list, shuffle elements randomly, etc.
3. datetime-The datetime module supplies classes for manipulating dates
and times. While date and time arithmetic is supported, the focus of
the implementation is on efficient attribute extraction for output
formatting and manipulation.
4. Platform-The Platform module is used to retrieve as much possible
information about the platform on which the program is being
currently executed. Now by platform info, it means information about
the device, its OS, node, OS version, Python version, etc.
5. OS-The OS module in Python provides functions for creating and
removing a directory (folder), fetching its contents, changing and
identifying the current directory, etc.

9
USER DEFINED FUNCTIONS USED:

1. registercust() :Using this function we will accept all the new

customer details.

2. chooseroom() :Using this function the customer can choose

the required rooms and the price for the
room is displayed.

3. restaurentmenuview() :Using this function the customer can view the

menu of our hotel.

4. orderitem() :Using this function the customer can choose

the desired food item.

5. laundrybill() :Using this function the customer can view

the price of the clothes

6. runagain() :Using this function the customer can again

choose from the menuset.

7. deletecust() :Using this function the customer can delete

the customer details.

MYSQL QUERIES USED IN THE PROJECT

 "insert into custdate(custname,addr,indate,outdate)

values('{}','{}','{}','{}')". format(name,addr,indate,outdate)"

 "select*from restaurant"

 "select * from restaurant"

 "select * from laundary"

10
SOURCE CODE

import os
import platform
import datetime
import random
import [Link]

mydb=[Link](user='root',password='Ramya@123',
host='localhost',database='hotel')
def registercust():
name=input("enter name:")
addr=input("enter address:")
indate=input("enter check in date:")
outdate=input("enter check out date:")
sql="insert into custdate (custname,addr,indate,outdate)values
(‘{}’,’{}’,’{}’,’{}’)”.format(name,addr,indate,outdate)
mycursor=[Link]()
[Link](sql)
[Link]()

11
def deletecust():
cname=input(“enter customer name to be deleted:”)
csql=”delete from custdate where custname=cname”
[Link](csql)
count=0
for custname in mycursor:
count+=1
print(“Record deleted successfully”)
if count==0:
print(“Record not found”)
[Link]()
def chooseroom():
s=0
print('Available room types:')
print('1. Single room/rs 2000 per night')
print('2. Twin room/rs 3000 per night')
print('3. Deluxe/rs 5000 per night')
print('4. Room with a view/rs 6500 per night')
print('5. Suite/rs 8000 per night')
choice=int(input('\nEnter your preferred choice:'))

12
if choice==1:
n=int(input('How many nights do you plan to stay:'))
print('You have opted a single room')
s=s+2000*n
room_no=[Link](1,501)
print('Your room number is:',room_no)

if choice==2:
n=int(input('How many nights do you plan to stay:'))
print('You have opted a twin room')
s=s+3000*n
room_no=[Link](501,1001)
print('Your room number is:',room_no)

if choice==3:
n=int(input('How many nights do you plan to stay:'))
print('You have opted a deluxe room')
s=s+5000*n
room_no=[Link](1001,1501)
print('Your room number is:',room_no)

13
 if choice==4:
n=int(input('How many nights do you plan to stay:'))
print('You have opted a room with a view')
s=s+6500*n
room_no=[Link](1501,2001)
print('Your room number is:',room_no)

if choice==5:
n=int(input('How many nights do you plan to stay:'))
print('You have opted a suite room')
s=s+8000*n
room_no=[Link](2001,2501)
print('Your room number is:',room_no)
print('\n Your room price is',s,'rs')

def restaurentmenuview():
print("Do you want to see menu available:Enter 1 for yes:")
ch=int(input("enter your choice:"))
if ch==1:
sql='select*from restaurant'
[Link](sql)
rows=[Link]()
print(x)

14
def orderitem():
print("Do you want to see menu available : Enter 1 for yes :")
ch=int(input("enter your choice:"))
if ch==1:
sql="select * from restaurant"
[Link](sql)
rows=[Link]()
for x in rows:
print(x)
d=int(input("enter your choice:"))
if d==1:
print("you have ordered tea")
a=int(input("enter quantity:"))
s=10*a
print("your amount for tea is:",s,"\n")
elif d==2:
print("you have ordered coffee")
a=int(input("enter quantity"))
s=10*a
print("you amount for coffee is:",s,"\n")

15
elif d==3:
print("you have ordered colddrink")
a=int(input("enter quantity"))
s=20*a
print("your amount for colddrink is:",s,"\n")
elif d==4:
print("you have ordered samosa")
a=int(input("enter quantity"))
s=10*a
print("your amount for samosa is:",s,"\n")
elif d==5:
print("you have ordered sandwich")
a=int(input("enter qunatity"))
s=50*a
print("your amount for sandwich is:",s,"\n")
elif d==6:
print("you have ordered dhokla")
a=int(input("enter quantity"))
s=30*a
print("your amount for dhokla is :",s,"\n")

16
elif d==7:
print("you have ordered kachori")
a=int(input("enter quantity"))
s=10*a
print("your amount for kachori is :",s,"\n")
elif d==8:
print("you have ordered milk")
a=int(input("enter quantity"))
s=20*a
print("your amount for kachori is :",s,"\n")
elif d==9:
print("you have ordered noodles")
a=int(input("enter quantity"))
s=250*a
print("your amount for noodles is :",s,"\n")
elif d==10:
print("you have ordered pasta")
a=int(input("enter quantity"))
s=150*a
print("your amount for pasta is :",s,"\n")
else:
print("please enter your choice from the menu")

17
def laundarybill():
global z
print("Do you want to see rate for laundary: Enter 1 for yes:")
ch=int(input("enter your choice:"))
if ch==1:
sql="select * from laundary"
[Link](sql)
rows=[Link]()
for x in rows:
print(x)
y=int(input("Enter Your number of clothes->"))
z=y*10
print("your laundary bill:",z,"\n")
return z
print("------WELCOME TO HOTEL TAJ-----")
print("DESCRIPTION")
print("The Taj Mahal Palace, Mumbai makes a wonderful starting point
from which to\
discover the charms that bring people from around the globe flocking to
Mumbai city,\
India’s commercial and entertainment capital. Around the corner from the
hotel is Colaba\
Causeway - a vibrant stretch filled with roadside stores, jewellery shops,
pubs and\
restaurants that whisks guests back in time to old Bombay. Take a tour of
and learn about\
18
the rich history and architecture of this vibrant city, accompanied by
Government of India\
appointed and trained tourism officials. The hotel has a peaceful
environment and a good place to\
recreate and enjoy your vacation tours. Hotel Taj will provide all your
necessity things and we want\
to make you comfortable and fulfullied. If you are joining to stay with us,
just call to 456 from\
our room and we will satisfy your needs. Thanks for visting our hotel")
def Menuset():
print("\nEnter 1:To enter customer data")
print("Enter 2:To view roomtype with price")
print("Enter 3:For viewing restaurent menu")
print("Enter 4:For restaurent bill")
print("Enter 5:For laundary bill")
print("Enter 6:To delete customer data:")
print(“Enter 7:For exit:”)
try:
userinput=int(input("please select an above option:"))
except ValueError:
exit("\n hi thats not a number")
if(userinput==1):
registercust()
elif(userinput==2):
chooseroom()

19
 elif(userinput==3):
restaurentmenuview()
elif(userinput==4):
orderitem()
elif(userinput==5):
laundarybill()
elif(userinput==6):
deletecust()
elif (userinput==7):
print(“Thanks for visting”)
else:
print("Enter correct choice")
Menuset()

def runagain():
runagn=input("Do you want to run again y/n:")
while([Link]()=='y'):
if([Link]()=="windows"):
p=0
else:
li=0
Menuset()
runagn=input("Do you want to run again y/n:")
runagain()

20
OUTPUT(SCREENSHOTS)

 To enter the customer details

21
 To add another customer details

 To view the type of room with price

22
 To view the restaurant bill

23
 To access the restaurant menu

24
 To view the laundary bill

25
 To delete the customer data

 To exit

26
MYSQL OUTPUT

 Create database and table custdate

 Details from custdate table

27
 Creating table restaurant and inserting values

 Details from laundary table

28
 Details from restaurant table

 Details before deleting a record

29
 Details after deleting a record

30
CONCLUSION:

The Hotel Management System was developed to replace the manual

process of booking a hotel room or any other facility of the hotel. Hotel
room reservation system makes easier you to book the rooms instantly and
your details is secured and we make it official. Your data is stored safe and
secure. It provides you with all the information regarding the room
booking.

Processing information will be faster. It guarantees accurate maintenance

of customer details. It easily reduces the book keeping task and thus
reduces the human effort and increases accuracy speed.

This computerized system store all the data in the database which makes it
easy to fetch and update whenever needed.

BIBILOGRAPHY:

Computer Science with Python by Sumita Arora for Class 11& 12

[Link]

[Link]

[Link]

31