Computer Science Project

2023-24
Topic : Hotel Management System
Guided By : Mr. SAROJ KANTA MISRA
Submitted By : KAUSTAV KUMAR (XII -‘A’)
Roll No. :
 CERTIFICATE
This is to certify that Kaustav Kumar of
class: XII A of PM SHRI KENDRIYA
VIDYALAYA BERHAMPUR has done his
project on HOTEL MANAGEMENT
SYSTEM under my supervision. He has
taken interest and has shown at most
sincerity in completion of this project.
I certify this project up to my expectation &
as per guidelines issued by CBSE, NEW
DELHI.

Internal Examiner External Examiner

Principal
ACKNOWLEDGMEN
T
It is with pleasure that I acknowledge my sincere
gratitude to our teacher, MR. S.K. MISRA who
taught and undertook the responsibility of
teaching the subject computer science. I have
been greatly benefited from his classes. I am
especially indebted to our Principal
MR.SHIVAPRIYA DASH who has always been a
source of encouragement and support and
without whose inspiration this project would not
have been a successful I would like to place on
record heartfelt thanks to him.
Finally, I would like to express my sincere
appreciation for all the other students for my
batch their friendship & the fine time that we all
shared together.

Student signature Principal Signature

HARDWARE AND
SOFTWARE
REQUIRED
HARDWARE
1. PC
2. MOBILE PHONE

SOFTWARE
1. PYTHON (latest version)
2. MYSQL
3. PYTHON-MYSQL CONNECTOR
 Contents
Sl.
No. Topics
1 About hotel
2 Introduction

3 Python Codes
4 Mysql Database
5 Output
6 References
HOTEL
A hotel is a commercial establishment that provides lodging,
accommodation, and other services to travelers or tourists.
Hotels typically offer a range of rooms or suites with varying
levels of amenities and services. These establishments can
vary widely in size and style, from small boutique hotels to
large luxury resorts.
Key features of hotels include:
1. Accommodation: Hotels provide rooms or suites for guests to
stay overnight or for an extended period.
2. Services: In addition to lodging, hotels often offer various
services such as room service, housekeeping, concierge, and
facilities like restaurants, gyms, swimming pools, conference
rooms, and more.
3. Classification: Hotels are often classified based on factors
like their size, amenities, and overall quality. Common
classifications include budget/economy hotels, mid-range
hotels, and luxury hotels.
4. Booking: Guests typically make reservations to secure their
accommodations in advance. This can be done through various
means, including online booking platforms, travel agencies, or
directly with the hotel.
5. Hospitality Industry: Hotels are an integral part of the
hospitality industry, which encompasses businesses that
provide services to travelers and customers seeking leisure
and comfort.
Overall, hotels play a crucial role in the travel and tourism
industry, offering a temporary home away from home for
individuals and groups seeking accommodation during their
travels.
 INTRODUCTION
The Hotel Management System (HMS) is a comprehensive
software solution designed to streamline and optimize the
operations of hotels and hospitality establishments. This
integrated system combines various modules to efficiently
manage different aspects of hotel functions, from
reservation and guest services to billing and inventory
management.

The reservation module of the HMS enables seamless

booking processes, allowing guests to make reservations
online or through the front desk. It maintains a centralized
database of room availability, ensuring accurate and up-to-
date information. The system also facilitates quick check-
ins and check-outs, enhancing the overall guest
experience.

Efficient guest services are a hallmark of the HMS, which

includes features such as room service management,
housekeeping, and personalized guest preferences. This
ensures a high level of customer satisfaction and loyalty.
Additionally, the system automates routine tasks, freeing
up staff to focus on providing exceptional service.
Financial management is another key component,
encompassing billing, invoicing, and reporting. The HMS
generates detailed financial reports, helping hotel owners
and managers make informed decisions to maximize
profitability. It also integrates with point-of-sale systems,
managing various revenue streams such as restaurants,
bars, and spa services.

Inventory management is crucial for maintaining optimal

stock levels in areas like housekeeping supplies and food
and beverage items. The HMS tracks inventory, automates
reordering processes, and minimizes wastage, contributing
to cost efficiency.

Security features, including user access controls and data

encryption, safeguard sensitive information and ensure
compliance with privacy regulations. The system also aids
in marketing efforts through guest relationship
management (CRM) tools, allowing hotels to personalize
promotions and loyalty programs.

In conclusion, the Hotel Management System is an

indispensable tool for modern hotels, enhancing
operational efficiency, improving guest satisfaction, and
ultimately contributing to the success of hospitality
businesses.
Key features of a Hotel Management System typically
include:
1. Reservation Management: Allows the hotel staff to
efficiently handle room bookings, cancellations,
and modifications. It helps in managing room
availability, rates, and guest preferences.
2. Front Desk Operations: Enables the front desk staff
to check-in/check-out guests, generate room keys,
and manage guest information. It may also include
features like guest folio creation and invoice
generation.
3. Billing and Invoicing: Handles the financial
aspects of guest stays, including room charges,
additional services, and taxes. It generates invoices
and receipts for guest.
4.Inventory Management : Tracks and manages hotel
inventory, including housekeeping supplies ,linens,
and other materials. This helps in maintaining
optimal stock levels and preventing shortages.
5. Housekeeping Management: Streamlines
housekeeping tasks such as room cleaning
schedules, maintenance requests, and inventory
restocking. It ensures rooms are prepared
efficiently for incoming guests.
6.Reporting and Analytics: Provides detailed reports
and analytics on various aspects of hotel
operations, allowing management to make
informed decisions. Reports may cover occupancy
rates, revenue, and guest demographics.
7. Point of Sale (POS):Manages the hotel's various
Revenue - generating outlets such as restaurants,
bars, spa, and other services. It helps in tracking
sales, inventory, and generating bills.
8.Guest Relationship Management (CRM): Helps in
building and maintaining relationships with guests
by managing guest profiles, preferences, and
feedback. This can lead to personalized services and
improved guest satisfaction.
9.Security and Access Control:Ensures the security of
guest data and property by implementing access
controls and monitoring systems. It may include
features like key card access and surveillance.
10. Channel Management: Manages the distribution
of room inventory across various online booking
channels to optimize occupancy rates and maximize
revenue.
11. Implementing a Hotel Management System not
only enhances operational efficiency but also
contributes to a better overall guest experience. The
system can be tailored to meet the specific needs of
different types and sizes of hospitality
establishments, including hotels, resorts, motels,
and bed-and-breakfasts.
PYTHON
CODES
 import mysql.connector
from tabulate import tabulate
import random
a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")
y=a.cursor()

#all details for admin

#to show employee details
def emp_details():

a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")
y=a.cursor()
q="select * from employees"
y.execute(q)
r = y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(r, headers=columns,
tablefmt="fancy_grid"))

#to show customer details

def customdet():
a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")

y=a.cursor()
x="select * from booking"
 y.execute(x)
r = y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(r, headers=columns,
tablefmt="fancy_grid"))
a.commit()

#to show room details(all rooms,vacant rooms,booked

rooms)
def room_details():
while True:
print("**********ROOM DETAILS**********")
print("1.Show Rooms")
print("2.Rooms Vacant")
print("3.Rooms Booked")
print("FOR EXIT ENTER ANY NO.: ")
ch=int(input("Enter your choice: "))
if ch==1:
show_rooms()
elif ch==2:
room_vacant()
elif ch==3:
rooms_booked()

else:
print("INVALID INPUT")
break
#to show all rooms
def show_rooms():
a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")
y=a.cursor()
y.execute("select room_type,prices,count(*) from rooms
group by room_type,prices;")
r = y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(r, headers=columns,
tablefmt="fancy_grid"))

#to show room vacant

def room_vacant():
a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")
y=a.cursor()
av="Available"
z="select * from rooms where Status ='{}'".format(av)
y.execute(z)
r = y.fetchall()

columns = [i[0] for i in y.description]

print(tabulate(r, headers=columns,
tablefmt="fancy_grid"))
#to show booked rooms
def rooms_booked():

a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")
y=a.cursor()
bk="Booked"
x="select * from rooms where Status ='{}'".format(bk)
y.execute(x)
r = y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(r, headers=columns,
tablefmt="fancy_grid"))

#to show restaurant details

def restaurant_details():
a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")
y=a.cursor()
z="select*from orders"
y.execute(z)

r = y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(r, headers=columns,
tablefmt="fancy_grid"))
#to show all feedback
def fedback():
a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")
y=a.cursor()
x="select * from fdback"
y.execute(x)
x = y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(x, headers=columns,
tablefmt="fancy_grid"))

#restaurant
def restaurant():
#VIEW MENU
def menu():

a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")
y=a.cursor()
b="select * from menu".format()
y.execute(b)
menu=y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(menu, headers=columns,
tablefmt="fancy_grid"))
if len(menu)>0:
print("Available")
a.commit()
 yn=int(input("Do uou want to order an item ?type(1
for yes/2 for back to main page):"))
if yn ==1:
b_order()
elif yn==2:
print("THANK YOU")
print("YOU HAVE BEEN REDIRECTED TO
MAIN PAGE")
customer_slot()

#BOOKING ORDER
def b_order():
a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")

y=a.cursor()
Id=int(input("ENTER DISH NO.: "))
Quantity=int(input("ENTER QUANTITY: "))
Name=input("ENTER YOUR NAME: ")
Mobile_No=int(input("Enter mobilr no."))
Address=input("Enter Address:")
f=("select * from menu where
Dish_ID={}").format(Id)
y.execute(f)
x=y.fetchall()
itn=x[0][1]
ip=x[0][3]
 tp=ip*Quantity
ins="insert into
orders(ID,Name,Quantity,Item_Price,Total_Price,Mobile_
No,Adress)values({},'{}',{},{},{},
{},'{}')".format(Id,itn,Quantity,ip,tp,Mobile_No,Address)
y.execute(ins)
print("THANKS FOR THE ORDER","\n\n","YOUR
ORDER HAS BEEN ORDERED SUCCESSFULLY","\n\
n")
print("YOU HAVE BEEN REDIRECTED TO THE
MAIN PAGE")
a.commit()

#VIEW ORDER
def vorders():
a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")
y=a.cursor()
m=int(input("Enter your number :"))
n="select * from orders where Mobile_No={}
".format(m)
print("\n","YOUR RECENT ORDERS","\n")
y.execute(n)
o=y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(o, headers=columns,
tablefmt="fancy_grid"))
for i in o:
p="select * from menu,orders where Mobile_No={}
and menu.Dish_ID=orders.ID".format(m)
y.execute(p)
q=y.fetchall()
a.commit()

#cancel order
def corder():
a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")
y=a.cursor()
x=int(input("enter your number:"))
s="delete from orders where
Mobile_No={}".format(x)
y.execute(s)
print("\n\n","YOUR ORDER HAS BEEN
CANCELLED")
print("YOU HAVE BEEN REDIRECTED TO THE
MAIN PAGE","\n\n")
a.commit()

#feedback
def fdback():
a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")
y=a.cursor()
fdn=input("Enter your name:")
print("Write something about us...")
fdi=input()
x="insert into fdback values('{}','{}')".format(fdn,fdi)
 y.execute(x)
print("\n\n")
print("THANKYOU FOR YOUR FEEDBACK")
print("\n")
print("YOU HAVE BEEN REDIRECTED TO THE
MAIN PAGE")
a.commit()
#welcome
def start1():
while True:
print("\n")
print("1. VIEW MENU")
print("2. VIEW YOUR ORDERS")
print("3. CANCEL ORDER")
print("4. FEEDBACK")
print("5. EXIT")
ch1=int(input(" enter your choice:"))
if ch1==1:
menu()
elif ch1==2:
vorders()
elif ch1==3:
corder( )
elif ch1==4:
fdback()
elif ch1==5:
break
 else:
print("\n","INVALID CHOICE"," \n" ,"TRY
AGAIN."," \n")

start1()

#booking rooms section

# Create the table if not exists
create_table = "CREATE TABLE IF NOT EXISTS
booking (Booking_ID int(10) PRIMARY KEY,Room_Type
varchar(20) not null,Guest_Name
VARCHAR(255),Phone_number varchar(15) not null,
Room_Number int(5) not null, Check_In_Date DATE,
Check_Out_Date DATE)"
y.execute(create_table)
def booking_id():
return random.randint(10000, 99999)
#to book room
def book_room(guest_name, ph_no,ro_no, check_in_date,
check_out_date, td1, pr):
try:
a = mysql.connector.connect(host="localhost",
user="root", password="admin",
database="hotel_sunset")

y = a.cursor()
b_id = booking_id()
 # Fetch available rooms
c = "SELECT * FROM rooms WHERE Status =
'Available' and room_no={}".format(ro_no)
y.execute(c)
d = y.fetchall()
if not d:
print("No available rooms.")
return None
e = d[0]
# Update room status to 'booked'
update_query = "UPDATE rooms SET Status =
'Booked' WHERE room_no = {}".format(ro_no)
y.execute(update_query)
# Insert booking record
ins = "INSERT INTO booking (Booking_ID,
Room_Type, Guest_Name, Phone_number,
Room_Number, Check_In_Date, Check_Out_Date,
Total_Days, Price)VALUES ({}, '{}', '{}', {}, {}, '{}', '{}', {},
'{}')".format(b_id, e[1], guest_name, ph_no, ro_no,
check_in_date, check_out_date, td1, pr)
y.execute(ins)
print("Room booked successfully! Room Number: ",
ro_no)

return b_id
except:
print("Error")
 finally:
a.commit()

#to book delux room

def book_delux_room():
a = mysql.connector.connect(host="localhost",
user="root", password="admin",
database="hotel_sunset")
y = a.cursor()
try:
z=random.randint(101, 111)
ro_no = z
g_name = input("Enter guest name: ")
ph_no = input("Enter your phone number: ")
in_date = input("Enter check-in date (YYYY-MM-
DD): ")
out_date = input("Enter check-out date (YYYY-MM-
DD):")
total_days_query = "SELECT DATEDIFF('{}',
'{}')".format(out_date, in_date)
y.execute(total_days_query)
td1 = y.fetchone()[0]
pr = 15000 * td1

booking_id = book_room(g_name, ph_no,ro_no,

in_date, out_date, td1, pr)
# Display booking history for the specific Booking_ID
if booking_id is not None:
 q = "SELECT * FROM booking WHERE
Booking_ID = {}".format(booking_id)
y.execute(q)
print("\nBooking History for Booking_ID {}:
".format(booking_id))
x = y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(x, headers=columns,
tablefmt="fancy_grid"))
except :
print("Error")

#to book double room

def book_double_room():
a = mysql.connector.connect(host="localhost",
user="root", password="admin",
database="hotel_sunset")
y = a.cursor()
try:
z=random.randint(201,211)
ro_no = z

g_name = input("Enter guest name: ")

ph_no = input("Enter your phone number: ")
in_date = input("Enter check-in date (YYYY-MM-
DD): ")
out_date = input("Enter check-out date (YYYY-MM-
DD):")
 total_days_query = "SELECT DATEDIFF('{}',
'{}')".format(out_date, in_date)
y.execute(total_days_query)
td1 = y.fetchone()[0]
pr = 25000 * td1
booking_id = book_room(g_name, ph_no,ro_no,
in_date, out_date, td1, pr)
# Display booking history for the specific Booking_ID
if booking_id is not None:
q = "SELECT * FROM booking WHERE
Booking_ID = {}".format(booking_id)
y.execute(q)
print("\nBooking History for Booking_ID {}:
".format(booking_id))
x = y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(x, headers=columns,
tablefmt="fancy_grid"))

except :
print("Error")

#to book king room

def book_king_room():
a = mysql.connector.connect(host="localhost",
user="root", password="admin",
database="hotel_sunset")
y = a.cursor()
 try:
z=random.randint(301,311)
ro_no = z
g_name = input("Enter guest name: ")
ph_no = input("Enter your phone number: ")
in_date = input("Enter check-in date (YYYY-MM-
DD): ")
out_date = input("Enter check-out date (YYYY-MM-
DD):")
total_days_query = "SELECT DATEDIFF('{}',
'{}')".format(out_date, in_date)
y.execute(total_days_query)
td1 = y.fetchone()[0]
pr = 40000 * td1
booking_id = book_room(g_name, ph_no,ro_no,
in_date, out_date, td1, pr)

# Display booking history for the specific Booking_ID

if booking_id is not None:
q = "SELECT * FROM booking WHERE
Booking_ID = {}".format(booking_id)
y.execute(q)
print("\nBooking History for Booking_ID {}:
".format(booking_id))
x = y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(x, headers=columns,
tablefmt="fancy_grid"))
 except :
print("Error")

#to book balcony rooms

def book_balcony_room():
a = mysql.connector.connect(host="localhost",
user="root", password="admin",
database="hotel_sunset")
y = a.cursor()
try:
z=random.randint(401,411)
ro_no = z
g_name = input("Enter guest name: ")
ph_no = input("Enter your phone number: ")

in_date = input("Enter check-in date (YYYY-MM-

DD): ")
out_date = input("Enter check-out date (YYYY-MM-
DD):")
total_days_query = "SELECT DATEDIFF('{}',
'{}')".format(out_date, in_date)
y.execute(total_days_query)
td1 = y.fetchone()[0]
pr = 45000 * td1
booking_id = book_room(g_name, ph_no,ro_no,
in_date, out_date, td1, pr)
# Display booking history for the specific Booking_ID
if booking_id is not None:
q = "SELECT * FROM booking WHERE
Booking_ID = {}".format(booking_id)
y.execute(q)
print("\nBooking History for Booking_ID {}:
".format(booking_id))
x = y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(x, headers=columns,
tablefmt="fancy_grid"))
except :
print("Error")

#to book cavana room

def book_cavana():
a = mysql.connector.connect(host="localhost",
user="root", password="admin",
database="hotel_sunset")
y = a.cursor()
try:
z=random.randint(501,506)
ro_no = z
g_name = input("Enter guest name: ")
ph_no = input("Enter your phone number: ")
in_date = input("Enter check-in date (YYYY-MM-
DD): ")
out_date = input("Enter check-out date (YYYY-MM-
DD):")
total_days_query = "SELECT DATEDIFF('{}',
'{}')".format(out_date, in_date)
 y.execute(total_days_query)
td1 = y.fetchone()[0]
pr = 90000 * td1
booking_id = book_room(g_name, ph_no,ro_no,
in_date, out_date, td1, pr)
# Display booking history for the specific Booking_ID
if booking_id is not None:
q = "SELECT * FROM booking WHERE

Booking_ID = {}".format(booking_id)
y.execute(q)
print("\nBooking History for Booking_ID {}:
".format(booking_id))
x = y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(x, headers=columns,
tablefmt="fancy_grid"))
except :
print("Error")

#user choice
def bookings():
try:
a = mysql.connector.connect(host="localhost",
user="root", password="admin",
database="hotel_sunset")
y = a.cursor()
z="select * from book_rooms"
y.execute(z)
 x = y.fetchall()
columns = [i[0] for i in y.description]
print(tabulate(x, headers=columns,
tablefmt="fancy_grid"))
roomchoice = int(input("Enter Your Option : "))
if roomchoice == 1:

book_delux_room()
elif roomchoice == 2:
book_double_room()
elif roomchoice == 3:
book_king_room()
elif roomchoice == 4:
book_balcony_room()
elif roomchoice == 5:
book_cavana()
else:
print("Sorry, May Be You Are Giving Me Wrong
Input, Please Try Again !!! ")
except:
print("Error")
finally:
y.close()
a.close()
#gaming section
def gaming():
print("1. Table Tennis -----> 15000 Rs./HR")
print("2. Bowling -----> 10000 Rs./HR")
print("3. Snooker -----> 25000Rs./HR")
print("4. VR World Gaming -----> 40000 Rs./HR")
print("5. Video Games -----> 35000 Rs./HR")
print("6. Swimming Pool Games -----> 50000
Rs./HR")
print("7. Exit")
game=int(input("Enter What Game You Want To Play :
"))
hour=int(input("Enter No Of Hours You Want To Play :
"))
if game==1:
print("YOU HAVE SELECTED TO PLAY : Table
Tennis")
gamingbill = hour * 15000
price=print("Total price = ",gamingbill,"Rs.")
elif game==2:
print("YOU HAVE SELECTED TO PLAY :
Bowling")
gamingbill = hour * 10000
price=print("Total price = ",gamingbill,"Rs.")
elif game==3:
print("YOU HAVE SELECTED TO PLAY :
Snooker")
gamingbill = hour * 25000
 price=print("Total price = ",gamingbill,"Rs.")
elif game==4:
print("YOU HAVE SELECTED TO PLAY : VR
World Gaming")
gamingbill = hour * 40000
price=print("Total price = ",gamingbill,"Rs.")
elif game==5:
print("YOU HAVE SELECTED TO PLAY :Video
Games")
gamingbill = hour * 35000
price=print("Total price = ",gamingbill,"Rs.")

elif game ==6:

print("YOU HAVE SELECTED TO PLAY :
Swimming Pool Games")
gamingbill = hour *50000
price=print("Total price = ",gamingbill,"Rs.")
else:
print("Sorry ,May Be You Are Giving Me Wrong
Input, Please Try Again !!! ")

#feedback to be asked by user

def feedback():

a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")
y=a.cursor()
fdn=input("Enter your name:")
print("Write something about us...")
 fdi=input()
x="insert into fdback values('{}','{}')".format(fdn,fdi)
y.execute(x)
print("\n\n")
print("THANKYOU FOR YOUR FEEDBACK")
print("\n")
print("YOU HAVE BEEN REDIRECTED TO THE
MAIN PAGE")
a.commit()

#for admin
def admin_slot():
while True:
print("*********WELCOME ADMIN*********")
print("1.Employees Details")
print("2.Coustomer Details")
print("3.Room Details")
print("4.Feedback")
print("5.Restaurant Details")
print("6.Exit")
a=int(input("enter your choice"))
if a==1:
emp_details()
elif a==2:
customdet()
elif a==3:
room_details()
 elif a==4:
fedback()
elif a==5:
restaurant_details()
elif a==6:
break
else:
print("\n\n","INVALID CHOICE","\n","TRY
AGAIN")

#for customer
def customer_slot():
while True:
print("*************NAMASTE*************")
print("1.RESTAURANT")
print("2.BOOK ROOMS")
print("3.GAMING")
print("4.FEEDBACK")
print("5.EXIT")
a=int(input("enter your choice"))
if a==1:
restaurant()
elif a==2:
bookings()
elif a==3:
gaming()
elif a==4:
feedback()
elif a==5:
 break

else:
print("\n\n","INVALID CHOICE")

#first interface
while True:
print("*********WELCOME TO HOTEL
SUNSET*********")
print("1.admin")
print("2.customer")
print("3.exit")
a=int(input("who are you"))
if a==1:
def admin_login(a, username, password):

a=mysql.connector.connect(host="localhost",user="root",
password="admin",database="hotel_sunset")
y=a.cursor()
try:

# Check if the provided username and password match an

admin record
query = "SELECT * FROM users WHERE
username = %s AND password = %s"
y.execute(query, (username, password))
admin_result = y.fetchone()
if admin_result:
print("Login successful. Welcome, Admin!")
 else:
print("Invalid username or password. Please
try again.")
except Exception as e:
print(f"Error: {e}")
a.close()
admin_username = input("Enter Admin Username:
")
admin_password = input("Enter Admin Password: ")
admin_login(a, admin_username, admin_password)
admin_slot()
elif a==2:
customer_slot()
elif a==3:
break
MYSQL
DATABASE
 All tables used:-

 Describing all tables:-

1. Booking:

2. Employees:
3. Feedback:

4. Menu:

5. Orders:
6. Rooms:

7. Room Details:

8. Users:
OUTPUT
S
 First interface with admin login:

 Customer login:

 From restaurant view menu:

 Order an item:

 View order:

 Canceling an order:

 Feedback of restaurant:
 Book a room:

 Gaming:

 Feedback for hotel:

 Viewing employee details:

 Viewing customer details:

 Viewing room details:

 Showing vacant rooms:

 Showing booked rooms:

 Viewing feedbacks from both hotel and restaurant:

 Viewing restaurant details:

 References
 Class 12 CS Sumita Arora book
 Class 11 CS Sumita Arora book
 Mysql
 Python IDLE
THANK
YOU