DBMS : MYSQL
HOST: LOCAL HOST
USER: ROOT
PASSWORD : ROOT
DATABASE : HOTEL
TABLE STRUCTURE : AS GIVEN BELOW
Mysql commands
create database hotel;
use hotel;
create table custdata(custname varchar(20),addr varchar (30),indate
varchar(10),outdate varchar(10));
create table roomtype (sno varchar(5),roomtype varchar(10),rent
integer(10)); insert into roomtype values ('1','type A',1000); insert into
roomtype values ('2','type B',2000); insert into roomtype values
('3','type C',3000); insert into roomtype values ('4','type D',4000);
create table restaurant (sno integer(10),itemname varchar(10),rate
integer(10)); insert into restaurant values(1,"tea",10); insert into
restaurant values(2,"coffee",10); insert into restaurant
values(3,"colddrink",20); insert into restaurant values(4,"samosa",10);
insert into restaurant values(5,"sandwich",50); insert into restaurant
values(6,"Dhokla",30); insert into restaurant values(7,"kachori",10);
insert into restaurant values(8,"milk",20); insert into restaurant
values(9,"noodles",50); insert into restaurant values(10,"pasta",50);
create table laundry(sno integer(10),itemname varchar(10),rate
integer(10)); insert into laundry values(1,"pant",10); insert into laundry
values(2,"shirt",10); insert into laundry values(3,"suit",10); insert into
laundry values(4,"sari",10);
PYTHON CODE :
import os import platform import [Link] import
pandas as pd import datetime global z mydb =
[Link](user='root', password='abha',
host='localhost',
database='hotel')
mycursor=[Link]()
def registercust():
L=[]
name=input("enter name:")
[Link](name)
addr=input("enter address:")
[Link](addr)
indate=input("enter check in date:")
[Link](indate)
outdate=input("enter check out date:") [Link](outdate)
cust=(L) sql="insert into
custdata(name,addr,indate,outdate)values(%s,%s,%s,%s)"
[Link](sql,cust) [Link]() def roomtypeview():
print("Do you want to see room type available : Enter 1 for
yes :") ch=int(input("enter your choice:")) if ch==1:
sql="select * from
roomtype"
[Link](sql)
rows=[Link]()
for x in rows: print(x)
def roomrent():
print ("We have the following rooms for
you:-") print ("1. type A---->rs 1000 PN\-")
print ("2. type B---->rs 2000 PN\-") print ("3.
type C---->rs 3000 PN\-") print ("4. type D----
>rs 4000 PN\-") x=int(input("Enter Your
Choice Please->")) n=int(input("For How
Many Nights Did You Stay:")) if(x==1):
print ("you have opted room type
A") s=1000*n elif (x==2):
print ("you have opted room type
B") s=2000*n elif (x==3):
print ("you have opted room type
C") s=3000*n elif (x==4):
print ("you have opted room type
D") s=4000*n else:
print ("please choose a room")
print ("your room rent is =",s,"\n") 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]()
for x in rows: print(x)
def orderitem(): global s 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)
print("do you want to purchase from above list:enter your
choice:") 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("your amount for coffee is :",s,"\n")
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 quantity")) 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")
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=50*a
print("your amount for noodles is :",s,"\n")
elif(d==10):
print("you have ordered pasta")
a=int(input("enter quantity"))
s=50*a print("your amount for pasta
is :",s,"\n") else:
Print("please enter your choice from the
menu") def laundarybill():
global z print("Do you want to see rate for laundry :
Enter 1 for yes :") ch=int(input("enter your choice:")) if
ch==1:
sql="select * from
laundry"
[Link](sql)
rows=[Link]()
for x in rows: print(x)
y=int(input("Enter Your number of
clothes->")) z=y*10 print("your laundry
bill:",z,"\n") return z def lb(): print(z) def
res(): print(s) def viewbill():
a=input("enter customer
name:") print("customer
name :",a,"\n") print("laundry
bill:") print(lb)
print("restaurant bill:")
print(res)
def Menuset():
print("enter 1: To enter customer data")
print("enter 2 : To view roomtype")
print("enter 3 : for calculating room bill")
print("enter 4 : for viewing restaurant
menu") print("enter 5 : for restaurant
bill") print("enter 6 :for laundry bill")
print("enter 7 : for complete bill")
print("enter 8 : for exit:") try:
userinput=int(input("pleaseselect an above option:"))
except ValueError:
exit("\n hi thats not a number")
userinput=int(input("enter your
choice")) if(userinput==1):
registercust()
elif(userinput==2):
roomtypeview()
elif(userinput==3):
roomrent()
elif(userinput==4):
restaurentmenuview()
elif(userinput==5):
orderitem()
elif(userinput==6):
laundarybill()
elif(userinput==7):
viewbill()
elif(userinput==8):
quit()
else:
print("enter correct
choice") Menuset() def
runagain():
runagn=input("\n want to run again
y/n:") while([Link]()=='y'):
if([Link]()=="windows"):
print([Link]('cls'))
else:
print([Link]('clear'))
Menuset() runagn=input("\n want to
run again y/n:") runagain()
Output