import mysql.
connector
myConnnection =""
cursor=""
userName=""
password =""
roomrent =0
restaurentbill=0
totalAmount=0
cid=""
#MODULE TO CHECK MYSQL CONNECTIVITY
def MYSQLconnectionCheck ():
global myConnection
global userName
global password
userName = input("\n ENTER MYSQL SERVER'S USERNAME : ")
password = input("\n ENTER MYSQL SERVER'S PASSWORD : ")
myConnection=mysql.connector.connect(host="localhost",user=userName,passwd=password ,auth_
plugin='mysql_native_password',charset='utf8')
if myConnection:
print("\n CONGRATULATIONS ! YOUR MYSQL CONNECTION HAS BEEN ESTABLISHED !")
cursor=myConnection.cursor()
cursor.execute("CREATE DATABASE IF NOT EXISTS HMS")
cursor.execute("COMMIT")
cursor.close()
return myConnection
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION CHECK USERNAME AND PASSWORD !")
MYSQLconnectionCheck ()
#MODULE TO ESTABLISHED MYSQL CONNECTION
def MYSQLconnection ():
global userName
global password
global myConnection
global cid
myConnection=mysql.connector.connect(host="localhost",user=userName,passwd=password ,
database="HMS" , auth_plugin='mysql_native_password' )
if myConnection:
return myConnection
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION !")
myConnection.close()
def userEntry():
global cid
if myConnection:
cursor=myConnection.cursor()
createTable ="CREATE TABLE IF NOT EXISTS C_DETAILS(CID VARCHAR(20),C_NAME
VARCHAR(30),C_ADDRESS VARCHAR(30),C_AGE VARCHAR(30),C_COUNTRY VARCHAR(30) ,P_NO
VARCHAR(30),C_EMAIL VARCHAR(30))"
cursor.execute(createTable)
cid = input("Enter Customer Identification Number : ")
name = input("Enter Customer Name : ")
address = input("Enter Customer Address : ")
age= input("Enter Customer Age : ")
nationality = input("Enter Customer Country : ")
phoneno= input("Enter Customer Contact Number : ")
email = input("Enter Customer Email : ")
sql = "INSERT INTO C_Details VALUES(%s,%s,%s,%s,%s,%s,%s)"
values= (cid,name,address,age,nationality,phoneno,email)
cursor.execute(sql,values)
cursor.execute("COMMIT")
print("\nNew Customer Entered in The System Successfully!")
cursor.close()
else:
print("\nERROR CUSTOMER NOT ENTERED IN SYSTEM !")
def bookingRecord():
global cid
customer=searchCustomer()
if customer:
if myConnection:
cursor=myConnection.cursor()
createTable ="CREATE TABLE IF NOT EXISTS BOOKING_RECORD(CID VARCHAR(20),CHECK_IN
DATE ,CHECK_OUT DATE)"
cursor.execute(createTable)
checkin=input("\n Enter Customer CheckIN Date [ YYYY-MM-DD ] : ")
checkout=input("\n Enter Customer CheckOUT Date [ YYYY-MM-DD ] : ")
sql= "INSERT INTO BOOKING_RECORD VALUES(%s,%s,%s)"
values= (cid,checkin,checkout)
cursor.execute(sql,values)
cursor.execute("COMMIT")
print("\nCHECK-IN AND CHECK-OUT ENTRY MADED SUCCESSFULLY !")
cursor.close()
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION !")
def roomRent():
global cid
customer=searchCustomer()
if customer:
global roomrent
if myConnection:
cursor=myConnection.cursor()
createTable ="CREATE TABLE IF NOT EXISTS ROOM_RENT(CID VARCHAR(20),ROOM_CHOICE
INT,NO_OF_DAYS INT,ROOMNO INT ,ROOMRENT INT)"
cursor.execute(createTable)
print ("\n ##### We have The Following Rooms For You #####")
print (" 1. Ultra Royal ----> 10000 Rs.")
print (" 2. Royal ----> 5000 Rs. ")
print (" 3. Elite ----> 3500 Rs. ")
print (" 4. Budget ----> 2500 USD ")
roomchoice =int(input("Enter Your Option : "))
roomno=int(input("Enter Customer Room No : "))
noofdays=int(input("Enter No. Of Days : "))
if roomchoice==1:
roomrent = noofdays * 10000
print("\nUltra Royal Room Rent : ",roomrent)
elif roomchoice==2:
roomrent = noofdays * 5000
print("\nRoyal Room Rent : ",roomrent)
elif roomchoice==3:
roomrent = noofdays * 3500
print("\nElite Royal Room Rent : ",roomrent)
elif roomchoice==4:
roomrent = noofdays * 2500
print("\nBudget Room Rent : ",roomrent)
else:
print("Sorry ,May Be You Are Giving Me Wrong Input, Please Try Again !!! ")
return
sql= "INSERT INTO ROOM_RENT VALUES(%s,%s,%s,%s,%s)"
values= (cid,roomchoice,noofdays,roomno,roomrent,)
cursor.execute(sql,values)
cursor.execute("COMMIT")
print("Thank You , Your Room Has Been Booked For : ",noofdays , "Days" )
print("Your Total Room Rent is : Rs. ",roomrent)
cursor.close()
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION !")
def Restaurent():
global cid
customer=searchCustomer()
if customer:
global restaurentbill
if myConnection:
cursor=myConnection.cursor()
createTable ="CREATE TABLE IF NOT EXISTS RESTAURENT(CID VARCHAR(20),CUISINE
VARCHAR(30),QUANTITY VARCHAR(30),BILL VARCHAR(30))"
cursor.execute(createTable)
print("1. Vegetarian Combo -----> 300 Rs.")
print("2. Non-Vegetarian Combo -----> 500 Rs.")
print("3. Vegetarian & Non-Vegetarian Combo -----> 750 Rs.")
choice_dish = int(input("Enter Your Cusine : "))
quantity=int(input("Enter Quantity : "))
if choice_dish==1:
print("\nSO YOU HAVE ORDER: Vegetarian Combo ")
restaurentbill = quantity * 300
elif choice_dish==2:
print("\nSO YOU HAVE ORDER: Non-Vegetarian Combo ")
restaurentbill = quantity * 500
elif choice_dish==3:
print("\nSO YOU HAVE ORDER: Vegetarian & Non-Vegetarian Combo ")
restaurentbill= quantity * 750
else:
print("Sorry ,May Be You Are Giving Me Wrong Input, Please Try Again !!! ")
return
sql= "INSERT INTO RESTAURENT VALUES(%s,%s,%s,%s)"
values= (cid,choice_dish,quantity,restaurentbill)
cursor.execute(sql,values)
cursor.execute("COMMIT")
print("Your Total Bill Amount Is : Rs. ",restaurentbill)
print("\n\n**** WE HOPE YOU WILL ENJOY YOUR MEAL ***\n\n" )
cursor.close()
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION !")
def totalAmount():
global cid
customer=searchCustomer()
if customer:
global grandTotal
global roomrent
global restaurentbill
if myConnection:
cursor=myConnection.cursor()
createTable ="CREATE TABLE IF NOT EXISTS TOTAL(CID VARCHAR(20),C_NAME
VARCHAR(30),ROOMRENT INT ,RESTAURENTBILL INT ,TOTAL_AMOUNT INT)"
cursor.execute(createTable)
sql= "INSERT INTO TOTAL VALUES(%s,%s,%s,%s,%s)"
name = input("Enter Customer Name : ")
grandTotal=roomrent + restaurentbill
values= (cid,name,roomrent,restaurentbill ,grandTotal)
cursor.execute(sql,values)
cursor.execute("COMMIT")
cursor.close()
print("\n **** CROWN PLAZA MIAMI **** CUSTOMER BIILING ****")
print("\n CUSTOMER NAME : " ,name)
print("\nROOM RENT : Rs. ",roomrent)
print("\nRESTAURENT BILL : Rs. ",restaurentbill)
print("___________________________________________________")
print("\nTOTAL AMOUNT : Rs. ",grandTotal)
cursor.close()
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION !")
def searchOldBill():
global cid
customer=searchCustomer()
if customer:
if myConnection:
cursor=myConnection.cursor()
sql="SELECT * FROM TOTAL WHERE CID= %s"
cursor.execute(sql,(cid,))
data=cursor.fetchall()
if data:
print(data)
else:
print("Record Not Found Try Again !")
cursor.close()
else:
print("\nSomthing Went Wrong ,Please Try Again !")
def searchCustomer():
global cid
if myConnection:
cursor=myConnection.cursor()
cid=input("ENTER CUSTOMER ID : ")
sql="SELECT * FROM C_DETAILS WHERE CID= %s"
cursor.execute(sql,(cid,))
data=cursor.fetchall()
if data:
print(data)
return True
else:
print("Record Not Found Try Again !")
return False
cursor.close()
else:
print("\nSomthing Went Wrong ,Please Try Again !")
print("""
************** Timpany Senior Secondary School **********************
***************HOTEL MANAGEMENT SYSTEM *************************
#******* Designed and Maintained By: ***************************
#******* Arush Kada - CLASS XII A ****
#******* Harsha Devara - CLASS XII A ****
#******* Aashmit Singh - CLASS XII A **** """)
myConnection = MYSQLconnectionCheck ()
if myConnection:
MYSQLconnection ()
while(True):
print('''1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT ''')
choice = int(input("Enter Your Choice"))
if choice ==2:
bookingRecord()
elif choice ==3:
roomRent()
elif choice ==4:
Restaurent()
elif choice ==5:
searchCustomer()
elif choice ==6:
totalAmount()
elif choice ==7:
searchOldBill()
elif (choice ==1):
userEntry()
elif choice ==8:
break
else:
print("Sorry ,May Be You Are Giving Me Wrong Input, Please Try Again !!! ")
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION !")
# END OF PROJECT
OUTPUTS
ENTER MYSQL SERVER'S USERNAME : root
ENTER MYSQL SERVER'S PASSWORD : 1234
CONGRATULATIONS ! YOUR MYSQL CONNECTION HAS BEEN ESTABLISHED !
************** Timpany Senior Secondary School **********************
***************HOTEL MANAGEMENT SYSTEM *************************
#******* Designed and Maintained By: ***************************
#******* Arush Kada - CLASS XII A ****
#******* Harsha Devara - CLASS XII A ****
#******* Aashmit Singh - CLASS XII A ****
ENTER MYSQL SERVER'S USERNAME : root
ENTER MYSQL SERVER'S PASSWORD : 1234
CONGRATULATIONS ! YOUR MYSQL CONNECTION HAS BEEN ESTABLISHED !
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice1
Enter Customer Identification Number : 1
Enter Customer Name : harsha
Enter Customer Address : vizag
Enter Customer Age : 18
Enter Customer Country : india
Enter Customer Contact Number : 9087654
Enter Customer Email : harsha6@gmail.com
New Customer Entered In The System Successfully !
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice1
Enter Customer Identification Number : 2
Enter Customer Name : aashmit
Enter Customer Address : vizag
Enter Customer Age : 18
Enter Customer Country : india
Enter Customer Contact Number : 987065
Enter Customer Email : aashmit3@gmail.com
New Customer Entered In The System Successfully !
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice1
Enter Customer Identification Number : 3
Enter Customer Name : arush
Enter Customer Address : vizag
Enter Customer Age : 18
Enter Customer Country : India
Enter Customer Contact Number : 890765
Enter Customer Email : arush78@gmail.com
New Customer Entered In The System Successfully !
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice2
ENTER CUSTOMER ID : 1
[('1', 'harsha', 'vizag', '18', 'india', '9087654', 'harsha6@gmail.com')]
Enter Customer CheckIN Date [ YYYY-MM-DD ] : 2024-11-08
Enter Customer CheckOUT Date [ YYYY-MM-DD ] : 2024-11-10
CHECK-IN AND CHECK-OUT ENTRY MADED SUCCESSFULLY !
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice2
ENTER CUSTOMER ID : 2
[('2', 'aashmit', 'vizag', '18', 'india', '987065', 'aashmit3@gmail.com')]
Enter Customer CheckIN Date [ YYYY-MM-DD ] : 2024-11-08
Enter Customer CheckOUT Date [ YYYY-MM-DD ] : 2024-11-09
CHECK-IN AND CHECK-OUT ENTRY MADED SUCCESSFULLY !
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice2
ENTER CUSTOMER ID : 3
[('3', 'arush', 'vizag', '18', 'India', '890765', 'arush78@gmail.com')]
Enter Customer CheckIN Date [ YYYY-MM-DD ] : 2024-11-08
Enter Customer CheckOUT Date [ YYYY-MM-DD ] : 2024-11-11
CHECK-IN AND CHECK-OUT ENTRY MADED SUCCESSFULLY !
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice3
ENTER CUSTOMER ID : 1
[('1', 'harsha', 'vizag', '18', 'india', '9087654', 'harsha6@gmail.com')]
##### We have The Following Rooms For You #####
1. Ultra Royal ----> 10000 Rs.
2. Royal ----> 5000 Rs.
3. Elite ----> 3500 Rs.
4. Budget ----> 2500 USD
Enter Your Option : 1
Enter Customer Room No : 222
Enter No. Of Days : 3
Ultra Royal Room Rent : 30000
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice3
ENTER CUSTOMER ID : 2
[('2', 'aashmit', 'vizag', '18', 'india', '987065', 'aashmit3@gmail.com')]
##### We have The Following Rooms For You #####
1. Ultra Royal ----> 10000 Rs.
2. Royal ----> 5000 Rs.
3. Elite ----> 3500 Rs.
4. Budget ----> 2500 USD
Enter Your Option : 2
Enter Customer Room No : 132
Enter No. Of Days : 2
Royal Room Rent : 10000
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice3
ENTER CUSTOMER ID : 3
[('3', 'arush', 'vizag', '18', 'India', '890765', 'arush78@gmail.com')]
##### We have The Following Rooms For You #####
1. Ultra Royal ----> 10000 Rs.
2. Royal ----> 5000 Rs.
3. Elite ----> 3500 Rs.
4. Budget ----> 2500 USD
Enter Your Option : 3
Enter Customer Room No : 345
Enter No. Of Days : 2
Elite Royal Room Rent : 7000
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice4
ENTER CUSTOMER ID : 1
[('1', 'harsha', 'vizag', '18', 'india', '9087654', 'harsha6@gmail.com')]
1. Vegetarian Combo -----> 300 Rs.
2. Non-Vegetarian Combo -----> 500 Rs.
3. Vegetarian & Non-Vegetarian Combo -----> 750 Rs.
Enter Your Cusine : 1
Enter Quantity : 1
SO YOU HAVE ORDER: Vegetarian Combo
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice4
ENTER CUSTOMER ID : 2
[('2', 'aashmit', 'vizag', '18', 'india', '987065', 'aashmit3@gmail.com')]
1. Vegetarian Combo -----> 300 Rs.
2. Non-Vegetarian Combo -----> 500 Rs.
3. Vegetarian & Non-Vegetarian Combo -----> 750 Rs.
Enter Your Cusine : 2
Enter Quantity : 1
SO YOU HAVE ORDER: Non-Vegetarian Combo
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice4
ENTER CUSTOMER ID : 3
[('3', 'arush', 'vizag', '18', 'India', '890765', 'arush78@gmail.com')]
1. Vegetarian Combo -----> 300 Rs.
2. Non-Vegetarian Combo -----> 500 Rs.
3. Vegetarian & Non-Vegetarian Combo -----> 750 Rs.
Enter Your Cusine : 3
Enter Quantity : 1
SO YOU HAVE ORDER: Vegetarian & Non-Vegetarian Combo
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice5
ENTER CUSTOMER ID : 1
[('1', 'harsha', 'vizag', '18', 'india', '9087654', 'harsha6@gmail.com')]
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice5
ENTER CUSTOMER ID : 2
[('2', 'aashmit', 'vizag', '18', 'india', '987065', 'aashmit3@gmail.com')]
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice5
ENTER CUSTOMER ID : 3
[('3', 'arush', 'vizag', '18', 'India', '890765', 'arush78@gmail.com')]
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice6
ENTER CUSTOMER ID : 1
[('1', 'harsha', 'vizag', '18', 'india', '9087654', 'harsha6@gmail.com')]
Enter Customer Name : harsha
**** CROWN PLAZA MIAMI **** CUSTOMER BIILING ****
CUSTOMER NAME : harsha
ROOM RENT : Rs. 7000
RESTAURENT BILL : Rs. 750
___________________________________________________
TOTAL AMOUNT : Rs. 7750
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice6
ENTER CUSTOMER ID : 2
[('2', 'aashmit', 'vizag', '18', 'india', '987065', 'aashmit3@gmail.com')]
Enter Customer Name : aashmit
**** CROWN PLAZA MIAMI **** CUSTOMER BIILING ****
CUSTOMER NAME : aashmit
ROOM RENT : Rs. 7000
RESTAURENT BILL : Rs. 750
___________________________________________________
TOTAL AMOUNT : Rs. 7750
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice6
ENTER CUSTOMER ID : 3
[('3', 'arush', 'vizag', '18', 'India', '890765', 'arush78@gmail.com')]
Enter Customer Name : arush
**** CROWN PLAZA MIAMI **** CUSTOMER BIILING ****
CUSTOMER NAME : arush
ROOM RENT : Rs. 7000
RESTAURENT BILL : Rs. 750
___________________________________________________
TOTAL AMOUNT : Rs. 7750
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice7
ENTER CUSTOMER ID : 1
[('1', 'harsha', 'vizag', '18', 'india', '9087654', 'harsha6@gmail.com')]
[('1', 'harsha', 7000, 750, 7750)]
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice7
ENTER CUSTOMER ID : 2
[('2', 'aashmit', 'vizag', '18', 'india', '987065', 'aashmit3@gmail.com')]
[('2', 'aashmit', 7000, 750, 7750)]
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice7
ENTER CUSTOMER ID : 3
[('3', 'arush', 'vizag', '18', 'India', '890765', 'arush78@gmail.com')]
[('3', 'arush', 7000, 750, 7750)]
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Display Customer Details
6--->GENERATE TOTAL BILL AMOUNT
7--->GENERATE OLD BILL
8--->EXIT
Enter Your Choice8
>>>
OUTPUTS
+----------------+
| Tables_in_hms |
+----------------+
| booking_record |
| c_details |
| restaurent |
| room_rent |
| total |
+----------------+
5 rows in set (0.00 sec)
mysql> select * from booking_record;
+------+------------+------------+
| CID | CHECK_IN | CHECK_OUT |
+------+------------+------------+
| 1 | 2024-11-08 | 2024-11-10 |
| 2 | 2024-11-08 | 2024-11-09 |
| 3 | 2024-11-08 | 2024-11-11 |
+------+------------+------------+
3 rows in set (0.00 sec)
mysql> select * from c_details;
+------+---------+-----------+-------+-----------+---------+--------------------+
| CID | C_NAME | C_ADDRESS | C_AGE | C_COUNTRY | P_NO | C_EMAIL |
+------+---------+-----------+-------+-----------+---------+--------------------+
| 1 | harsha | vizag | 18 | india | 9087654 | harsha6@gmail.com |
| 2 | aashmit | vizag | 18 | india | 987065 | aashmit3@gmail.com |
| 3 | arush | vizag | 18 | India | 890765 | arush78@gmail.com |
+------+---------+-----------+-------+-----------+---------+--------------------+
3 rows in set (0.00 sec)
mysql> select * from restaurent;
Empty set (0.00 sec)
mysql> select * from room_rent;
Empty set (0.00 sec)
mysql> select * from total;
+------+---------+----------+----------------+--------------+
| CID | C_NAME | ROOMRENT | RESTAURENTBILL | TOTAL_AMOUNT |
+------+---------+----------+----------------+--------------+
| 1 | harsha | 7000 | 750 | 7750 |
| 2 | aashmit | 7000 | 750 | 7750 |
| 3 | arush | 7000 | 750 | 7750 |
+------+---------+----------+----------------+--------------+
3 rows in set (0.00 sec)
