WIXLIB

COMPUTER SCIENCE INVESTIGATORY FILETOPIC:- HOTEL MANAGEMENTSUBMITTED TO:MRS. SANGEETA CHAUHANSUBMITTED BY:DEEPAK SINGH KUSHWAHABOARD ROLL NO.: 196119825

ABSTRACT:The ultimate motto ofthis project is to helpthe travelers to get allthe info about roomsPrices, room’savailability, food andother necessaryinformation for hotelroom booking. Thisproject helps the usersto carry this taskonline easily.THE TAJ HOTELHOTELMANAGEMENT

CERTIFICATETHIS IS TO CERTIFY THAT DEEPAK SINGH, A STUDENT OFCLASSXII-B IS SUCCESSFULLY COMPLETED THAT PROJECTTITLED “HOTEL MANAGEMENT” UNDER THE GUIDANCE OFMRS. SANGEETA M. CHAUHAN (SUBJECT TEACHER) DURINGTHE ACADEMIC YEAR 2019-20 IN PARTIAL FULFILLMENT OFCOMPUTER SCIENCE PRACTICAL EXAMINATION CONDUCTEDBY CENTRAL BOARD OF SECONDARY EDUCATION.SIGNATUREEXTERNAL EXAMINERSIGNATURE OF PRINCIPALSIGNATUREINTERNAL EXAMINER

ACKNOWLEDGMENTIN THE ACCOMPLISHMENT OF THIS PROJECT SUCCESSFULLY,MANY PEPOLE HAVE BEST OWNED UPON ME THEIRBLESSINGS AND THE HEART PLEDGE SUPPORT, THIS TIME IAM UTILIZING TO THANK ALL THE PEPOLE WHO HAVE BEENCONCERNED WITH PROJECT.PRIMARILY I WOULD THANL GOD FOR BEING ABLE TOCOMPLETE THIS PROJECT SUCCESS. THEN I WOULD LIKE TOTHANK MY PRINCEPAL MR. RAGHVENDRA LALSATANIA ANDCOMPUTER SCIENCE TEACHER MRS. SANGEETA M.CHAUHAN WHOSE VALUABLE GUIDACE HAS BEEN ONESTHAT HELPED ME PATCH PROJECT AND MAKE IT FULLPROOF SUCCESSS HIS SUGGESTION AND HIS INSTRUCTIONHAS SERVE AS THE MAJOR CONTRIBUTION TOWARDS THECOMPLETION OF THE PROJECT.THEN I WOULD LIKE TO THANK MY PARENTSS AND FRIENDSWHO HAVE HELPED ME WITH THEIR VALUABLE SUGGESTIONAND GUIDANCE HAS BEEN HELPFUL IN VARIOUS PHASES OFTHE COMPLETION OF THE PROJECT.

TRODUCTION TO PROJECT4.CODING5.OUTPUTS6.BIBLIOGRAPHY

INTRODUCTIONMy project on “HOTEL MANAGEMENT” gives idea about themanagement in hotels. The package gives all the informationregarding the check in or check out facilities of customer. Thecustomer can made his or her booking for rooms and foodetc. It gives details of the customer and the time of arrivaland departure of customer. The package also provides thefacility of searching the customer or employee working inthat particular hotel by name/by provided Id. It gives adetailed report of the customer and the room occupied byhim/her. This software is very useful to the departments formanaging their activities.Although, hotels are already having well-developed softwarefor information management. We just want to study how thisis done. So, I selected hotel management system as myproject. I visited various hotels and gone through theirsoftware. In most of the hotel the back-end used only MSACCESS. But I included SQL in my since it is pure relationaldatabase. In one of hotel, I found that they have problemthat software does not show the room vacant as soon as itbeing vacant. The status of room is updated only after 12hours or 24 hours depending upon the time period the havetaken. They were facing problem in providing and at anymoment of time the status of room that whether it is vacantor occupied is shown correctly.

##Creating Database and Table*******************************import mysql.connectordb mysql.connector.connect(host 'localhost',user 'root',password 'deepak')mycursor db.cursor()mycursor.execute('create database if not exists HOTEL MANAGEMENT')db mysql.connector.connect(host 'localhost',user 'root',password 'deepak',database 'HOTEL MANAGEMENT')mycursor db.cursor()mycursor.execute("create table if not exists hoteldata(Ccode int(5) primary key,Cname\varchar(20),Cadd varchar(20),Cindate varchar(5),Coutdate varchar(5),Room no varchar(5),\Room rent varchar(10),Food bill varchar(10) default '00',Laudry bill varchar(10) default\'00',Game bill varchar(10) default '00',SubTotal bill varchar(10),Add charges varchar(10)\default '1800',GrandTotal bill varchar(10))") :mycursor.execute("insert into hoteldata values(25,'Deepak','Morar,Gwalior',25,26,\1000, "insert into hoteldata ,0,50,10155,1800,11955)")mycursor.execute("insert into hoteldata values(27,'Anuj','New ycursor.execute("insert into hoteldata 0,0,90,9110,1800,10910)")mycursor.execute("insert into hoteldata 0,30075,1800,31875)")mycursor.execute("insert into hoteldata ,30036,1800,31836)")

mycursor.execute("create table if not exists Room(Rooms varchar(10),Type varchar(45),\Charges int(7),Features varchar(90),Occupancy int(45))") :mycursor.execute("insert into Room values('1-500','Duplex',6000,'Two rooms on\same floor connected by common stairs',5)")mycursor.execute("insert into Room values('501-1000','Cabana',5000,'Faces water\body,beach or a swimming pool',3)")mycursor.execute("insert into Room values('1001-1500','Lanai',4000,'This room faces\a landscape, a waterfall, or a garden',4)")mycursor.execute("insert into Room values('1501-2000','Suit',3000, 'It is composed of\one or more bedrooms, a living room, and a dining area',12)")mycursor.execute("create table if not exists Customer(Ccode int(5),Cid type varchar\(20),Cid no varchar(15) primary key , Cname varchar(15), Ccontact no varchar(15),Cadd\varchar(20),Cindate varchar(5), Coutdate varchar(5), CNationality varchar(10))") :mycursor.execute("insert into Customer values(25,'Aadhaar lior',25,26,'Indian' )")mycursor.execute("insert into Customer values(26,'Pan card', 'Indian')")mycursor.execute("insert into Customer values(27,'Pan card', 8456958236, 'Anuj',\9770563593,'New Delhi',12,20,'Indian')")mycursor.execute("insert into Customer values(28,'Service ,5,8,'Indian')")mycursor.execute("insert into Customer values(29,'Voter Id 'Canadian')")mycursor.execute("insert into Customer values(30,'Aadhaar ,30,'American')")db.commit()

def speciality():db mysql.connector.connect(host 'localhost',user 'root',password 'deepak',database ‘HOTEL MANAGEMENT')mycursor db.cursor()qry ("select * from 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\the rich history and architecture of this vibrant city, accompanied by Government of India\appointed and trained tourism officials.Walk past Gothic buildings and through narrow\streets.Visit historic locations such as Wellington Fountain, Regal Cinema, Indian Merchant\Building, Asiatic Library, CSMVS Museum, Jehangir Art Gallery, Elphinstone College and\other prominent buildings in varying styles of architecture, each symbolic of a particular\period of Bombay’s social and commercial history.\n")for (Rooms,Type,Charges,Features,Occupancy) in mycursor:print("We have Rooms",Rooms,"of type",Type,",it has",Features,"and t("SERVICES:")print("For the disabled, Breakfast, Restaurant, Adsl wi-fi internet, Fax, Newspapers,\Transfer, Tourist information, Small animals welcome, Private parking,Guarded garage,\24h reception, 24h bar, Beaches at 500 m, Shuttle bus stop for the airport only 10 ionHall, Bar, Pool 10.00 a.m. – 6.00 p.m.\n")print("BOOKING:")print("Excursions, Guided tours, Private parties")mycursor.close()db.close()

##Function, hotel fare calculator**********************************def hotelfarecal():while True :print("\n")print(" ")print("1.Booking for Room")print("2.Show Customer Record")print("3.Search Customer Record")print("4.Delete Customer Record")print("5.Update Customer Record")print("6.Return to Main Menu")print(" ")b (input("\nEnter your choice:"))if (b '1'):z 'y'while (z 'y'):inputdata()z input("\nDo you want to continue.(y/n):")if (z 'n'):return hotelfarecal()else :print("Invalid Input!!")z input("\nDo you want to continue.(y/n):")

elif (b '2'):z 'y'while z 'y':display()z input("\nDo you want to continue.(y/n):")If (z 'n'):return hotelfarecal()else :print("Invalid Input!!")z input("\nDo you want to continue.(y/n):")elif (b '3'):z 'y'while (z 'y'):search()z input("\nDo you want to continue.(y/n):")if (z 'n'):return hotelfarecal()else :print("Invalid Input!!")z input("\nDo you want to continue.(y/n):")elif (b '4'):z 'y'while (z 'y'):

delete()z input("\nDo you want to continue.(y/n):")if (z 'n'):return hotelfarecal()else :print("Invalid Input!!")z input("\nDo you want to continue.(y/n):")elif (b '5'):z 'y'while (z 'y'):update()z input("\nDo you want to continue.(y/n):")if (z 'n'):return hotelfarecal()else :print("Invalid Input!!")z input("\nDo you want to continue.(y/n):")elif (b '6'):breakelse:print("Invalid Input.")

##Inserting data******************import mysql.connectorimport randomdef inputdata():r 0l 0p 0s 0db mysql.connector.connect(host 'localhost',user 'root',password 'deepak',database 'HOTEL MANAGEMENT')mycursor db.cursor()Ccode input("\nEnter Customer Code:")Cname input("Enter Customer Name:")Cadd input("Enter Customer Address:")Cindate input("Enter Customer Check in Date:")Coutdate input("Enter Customer Check out Date:")Cid type input("Enter your Identity card name:")Cid no input("Enter your Identity number:")Ccontact no input("Enter you Contact number:")CNationality input("Enter your nationality:")print("\n")

##Choose Room for rent***********************print ("We have the following rooms for you:-")print ("1. Duplex---- Rs 6000 PN\-")print ("2. Cabana---- Rs 5000 PN\-")print ("3. Lanai---- Rs 4000 PN\-")print ("4. Suit---- Rs 3000 PN\-")print ("5. Mini---- RS 2000 PN\-")print ("6. Next")while (1):x int(input("\nEnter you choice:"))if (x 1):n int(input("For How Many Nights Did You Stay:"))print ("You have opted room Duplex")s s 6000*nRoom no random.randint(1,501)print("Your Room Number is:",Room no)elif (x 2):n int(input("For How Many Nights Did You Stay:"))print ("You have opted room Cabana")s s 5000*nRoom no random.randint(501,1001)print("Your Room Number is:",Room no)

elif (x 3):n int(input("For How Many Nights Did You Stay:"))print ("You have opted room Lanai")s s 4000*nRoom no random.randint(1001,1501)print("Your Room Number is:",Room no)elif (x 4):n int(input("For How Many Nights Did You Stay:"))print ("You have opted room Suit")s s 3000*nRoom no random.randint(1501,2001)print("Your Room Number is:",Room no)elif (x 5):n int(input("For How Many Nights Did You Stay:"))print ("You have opted room Cabana")s s 5000*nRoom no random.randint(2001,2501)print("Your Room Number is:",Room no)elif (x 6) :breakelse:print ("Please choose a room")print ("\nYour room rent is",s,'RS')

##Choose Restaurant ***RESTAURANT MENU*****")print("1.water----- Rs20","2.tea----- Rs10","3.breakfast combo--- Rs90","4.lunch---- \Rs110","5.dinner--- Rs150","6.Next")while (1):c int(input("\nEnter your choice:"))if (c 1):d int(input("Enter the quantity:"))r r 20*delif (c 2):d int(input("Enter the quantity:"))r r 10*delif (c 3):d int(input("Enter the quantity:"))r r 90*delif (c 4):d int(input("Enter the quantity:"))r r 110*delif (c 5):d int(input("Enter the quantity:"))r r 150*delif (c 6):breakelse:print("Invalid option")print ("\nTotal food Cost Rs ",r)

##Choose Laundry Menu***********************print ("\n")print ("******LAUNDRY MENU*******")print ("1.Shorts----- Rs3","2.Trousers----- Rs4","3.Shirt--- Rs5","4.Jeans---- Rs6",\"5.Girlsuit--- Rs8","6.Next")while (1):e int(input("\nEnter your choice:"))if (e 1):f int(input("Enter the quantity:"))l l 3*felif (e 2):f int(input("Enter the quantity:"))l l 4*felif (e 3):f int(input("Enter the quantity:"))l l 5*felif (e 4):f int(input("Enter the quantity:"))l l 5*felif (e 5):f int(input("Enter the quantity:"))l l 6*felif (e 6):breakelse:print ("Invalid option")print ("\nTotal Laundary Cost Rs",l)