Computer science project.pdf

Computer science project class 12 in python on food management system you guys can simply use it.

1. AProjectReportOn
“FOODBOOKINGSYSTEM”
SUBMITTED BY:
NAME
CLASS:12
BOARDROLLNO.:
UNDERTHEGUIDANCEOF:
Mr.Mani

2. ACKNOWLEDGEMENT
Thisistocertifythat HARSHIT
Ofclass12haspreparedthereporton
theProjectentitled “FoodBooking
System”.Thereportistheresultofhis
effortsandendeavors.Thereportisfound
worthyofacceptanceasfinalproject
reportforthesubject ComputerScience
ofclassXII.Hehaspreparedtheproject
undertheguidanceofthesubjectteacher,
Mr.Mani.
(Mr.Mani)

3. CERTIFICATE
Theprojectreportentitled“FOODBOOKINGSYSTEM”
SubmittedbyHARSHITofClassXIIfortheC.B.S.E.
SeniorSecondaryExaminationclassXIIof
computerscienceundertheguidanceofthesubject
teacher,Mr.Maniisfoundtobecorrectunderall
means.
SIGNATURE

4. DECLARATION
Iherebydeclarethattheprojectworkentitled“Food
BookingSystem”,submittedtoDepartmentof
computerscience,_____________PUBLICSCHOOLis
preparedbyme.Allthecodingareresultofmy
personalefforts.
HARSHIT
12-D

5. INDEX
1.BriefoverviewoftheProject
2.NeedofComputerization
3.SoftwareandHardwarerequirement
4.AdvantagesoftheProject
5.SourcecodeofProject
6.OutputScreens
7.Bibliography

6. FOODBOOKINGSYSTEM
BRIEFOVERVIEWOFPROJECT..
Themainobjectiveofthepythonprojecton
Foodorderingistomanagethedetailsof
booking,menupayments,andorder.
Theprojectistotallybuiltat
administrativeendandonlyadministrator
isguaranteedtheaccess.
Thepurposeoftheprojectistobuildan
applicationprogramtoreducethemanual
workformanagingthebooking,
discounts,andpayments.
Ittracksallthedetailsaboutmenu,
discount,andpayments;italsoprints
variousreportsasperinputgivenbythe
user.

7. INPUTDATAANDVALIDATIONOFPROJECT
1.Allthefieldssuchasorderpaymentsdiscountsare
validatedanddoesnottakeinvalidvalues.
2.Eachformofsales,discounts,bookingscannot
accepttheblankvalues.
3.Avoidingerrorsindata.
4.Controllingamountofinput.
SOFTWAREANDHARDWAREREQUIREMENTS:
Datafilehandling:
hasbeeneffectivelyusedintheprogram.The
databaseisacollectionofinterrelateddata
toservemultipleapplications.Thatis
databaseprogramscreatefilesofinformation.
Soweseethatfilesareworkedwithmost,
insidetheprogram.
DBMS:
Thesoftwarerequiredforthemanagementof
dataiscalledasDBMS.Ithas3models:
•Relationmodel
•Hierarchicalmodel
•Networkmodel
RELATIONALMODEL:
It’sbasedontheconceptonrelation.Relation
isthetablethatconsistsofrowsandcolumns.
Therowsofthetablearecalledtupleandthe

8. columnsofthetablearecalledattribute.
Numbersofrowsinthetableiscalledas
cardinality.Numberofcolumnsinthetableis
calledasdegree.
HIERARCHICALMODEL:
Inthistypeofmodel,wehavemultiplerecordsforeach
record.Aparticularrecordhasoneparentrecord.Nochide
recordcanexistwithoutparentrecord.Inthis,the
recordsareorganizedintree.NETWORKMODEL:
Inthis,thedataisrepresentedbycollectionofrecords
andrelationshipisrepresentedby(inkorassociation.
CHARACTERISTICSOFDBMS:
•
Itreducestheredundancy
•Reductionofdataininconsistency
•Datasharing
•Datastandardization
DIFFERENTTYPESOFFILES:-BASEDONACCESS :
•
Sequentialfile
•Serialfile
•Random(directaccess)fileBASEDONSTORAGE:-
•Textfile
•BinaryFile

9. NEEDOFCOMPUTERISATION
Overthedecadescomputersandfoodbookingshave
developedgradually,changedwithtime.Butnobody
knewthatatimewillcomewhenboththesefields
willcomplementeachothersowell.Todayfood
bookinghasreachednewheightsbycomputeraided
methodsofdesign.Asaresultofwhich,computer
industryhasgotitsnewcustomer.Computer
technologyismakingwavesinthefoodbookingzone.
Computersareavitalcomponentofthefoodbooking
counters.Computeraideddesign(CAD)programs
reducethedemandformanualsketches.Newsoftware
programscontinuetoreplaceoldmanualskills.
Thosewholaginmathcannowbreathealittle
easier.Manuallyfiguringoffoodinsiststhat
knowledge.Softwareprogramsconstantlyevolve.A
programusedtodaymaybeobsoletewithinseveral
years.Beingtrainedontoday'ssoftwaredoesnot
guaranteeitwillbeusedwhenyouarereadytogo
outintothefield.Understandingcalculationsis
timeless,asiscomputercompetency.Software,
however,shiftsrapidly.

10. ADVANTAGES
1.
I
tgeneratesthereportonsales,discountsandmenu.
2.Providesfilterreportonpaymentsandfoodbooking.
3.WecaneasilyexportPDFonsales,productsandstocks
4.Applicationscanalsoprovideexcelexportforbookingsand
discounts
5.Itdealswithmonitoringtheinformationandtransactionof
foodbookings.
6.Itincreasestheefficiencyoffoodbookinganddiscount.
7.Ithashigherefficiencyofediting,addingandupdatingof
records.
8.Providesthesearchingfacilitiesonvariousfactors.

11. SOURCECODESCREEN
DBMS:MySQL
Host:localhost
User:root
Password:root
Database:Food
TableStructure:(Imagebelow)

12. PYTHONCODE
importos
importplatform
importmysql.connector
importpandasaspd
mydb=mysql.connector.connect(host="localhost",\
user="root",\
passwd="root",\
database="food")
mycursor=mydb.cursor()
defCustomer():
L=[]
c_id=int(input("EnterthecustomerIDnumber:"))
L.append(c_id)
name=input("EntertheCustomerName:")
L.append(name)
cphone=int(input("Entercustomerphonenumber:"))
L.append(cphone)
payment=int(input("Enterpaymentmethod((1)credit
card/(2)DebitCard:)"))
L.append(payment)
pstatus=input("Enterthepaymentstatus:")
L.append(pstatus)
email=input("Entertheemailid")
L.append(email)
orderid=input("enterorderid")
L.append(orderid)
date=input("EntertheDate:")
L.append(date)
cust=(L)
sql="insertintocustomer
(c_id,name,cphone,payment,pstatus,email,orderid,date)
values(%s,%s,%s,%s,%s,%s,%s,%s)"
mycursor.execute(sql,cust)

13. mydb.commit()
#CustomerTable:-C_id(PKC_nameC_phonenum
Payment_method(Cash/CreditCard)Payment_status
(Paid/Unpaid)EmailEmp_id(FK)OrderF_id(FK)date
defEmployee():
L=[]
Emp_id=int(input("EntertheEmployeeid:"))
L.append(Emp_id)
ename=input("EntertheEmployeeName:")
L.append(ename)
emp_g=input("EnterEmployeeGenderr:")
L.append(emp_g)
eage=int(input("EnterEmployeeage"))
L.append(eage)
emp_phone=int(input("enteremployeephonenumber"))
L.append(emp_phone)
pwd=input("Enterthepassword:")
L.append(pwd)
EMP=(L)
sql="insertintoEmployee
(Emp_id,ename,emp_g,eage,emp_phone,pwd)values
(%s,%s,%s,%s,%s,%s)"
mycursor.execute(sql,EMP)
mydb.commit()
defFood():
L=[]
Food_id=int(input("EntertheFoodid:"))
L.append(Food_id)
Foodname=input("EntertheFoodName:")
L.append(Foodname)
Food_size=input("EnterFoodsize:")
L.append(Food_size)
prize=int(input("EnterPrizeofFood"))
L.append(prize)
Food=(L)

14. sql="insertintoFood
(Food_id,Foodname,Food_size,prize)values(%s,%s,%s,%s)"
mycursor.execute(sql,Food)
mydb.commit()
#Food_id(PKFoodnameFood_sizeprice
defOrderFood():
L=[]
OrderF_id=int(input("EntertheFoodOrderid:"))
L.append(OrderF_id)
C_id=input("EntertheCustomerid:")
L.append(C_id)
Emp_id=input("EnterEmployeeid:")
L.append(Emp_id)
Food_id=int(input("EnterFoodid"))
L.append(Food_id)
Food_qty=input("EnterQty:")
L.append(Food_qty)
Total_price=input("EnterTotal_price")
L.append(Total_price)
OrderFood=(L)
sql="insertintoOrderFood
(OrderF_id,C_id,Emp_id,Food_id,Food_qty,Total_price)
values(%s,%s,%s,%s,%s,%s)"
mycursor.execute(sql,OrderFood)
mydb.commit()
#OrderF_id(PK)C_id(FK)Employee_id(FK)Food_id(FK)
Food_qtyTotal_price
defView():
print("Selectthesearchcriteria:")
print("1.Employee")
print("2.Customer")
print("3.Food")
print("4.OrderFood")

15. ch=int(input("Enterthechoice1to4:"))
ifch==1:
s=int(input("enterEmployeeID:"))
rl=(s,)
sql="select*fromEmployeewhereEmp_id=%s"
mycursor.execute(sql,rl)
res=mycursor.fetchall()
forxinres:
print(x)
elifch==2:
s=input("EnterCustomerName:")
rl=(s,)
sql="select*fromCustomerwherecname=%s"
mycursor.execute(sql,rl)
res=mycursor.fetchall()
forxinres:
print(x)
elifch==3:
sql="select*fromFood"
mycursor.execute(sql)
res=mycursor.fetchall()
forxinres:
print(x)
elifch==4:
s=int(input("EnterFoodidID:"))
rl=(s,)
sql="select*fromFoodorderwherefood_id=%s"
mycursor.execute(sql,rl)
res=mycursor.fetchall()
forxinres:
print(x)
#print("TheFooddetailsareasfollows:")
#print("(CustoemerID,FoodName,quatity,Cost)")

16. #forxinres:
#print(x)
deffeeDeposit():
L=[]
roll=int(input("Entertherollnumber:"))
L.append(roll)
feedeposit=int(input("EntertheFeetobedeposited:
"))
L.append(feedeposit)
month=input("Entermonthoffee:")
L.append(month)
fee=(L)
sql="insertintofee(roll,feedeposit,month)values
(%s,%s,%s)"
mycursor.execute(sql,fee)
mydb.commit()
defMenuSet():
print("Enter1:ToAddEmployee")
print("Enter2:ToAddCutomerdetails")
print("Enter3:ToAddFoodDetails")
print("Enter4:ForFoodOrder")
print("Enter5:ForfeeDeposit")
print("Enter6:ToviewFoodbooking")
try:
userInput=int(input("PleaseSelectAnAbove
Option:"))
exceptValueError:
exit("\nHy!That'sNotANumber")
else:
print("\n")
if(userInput==1):
Employee()
elif(userInput==2):
Customer()
elif(userInput==3):

17. Food()
elif(userInput==4):
OrderFood()
elif(userInput==5):
feeDeposit()
elif(userInput==6):
View()
else:
print("Entercorrectchoice...")
defrunAgain():
runAgn=input("\nwanttorunAgainY/N")
whilerunAgn.lower()=='y':
if(platform.system()=="Windows"):
print(os.system('cls'))
else:
print(os.system('clear'))
MenuSet()
runAgn=input("\nwanttorunAgainy/n")
print("GoodBye...HAVEANICEDAY")
MenuSet()
runAagain()

18. OUTPUTSCREEN

19. BIBLIOGRAPHY
1.http://www.google.com/
2.http://en.wikipedia.org
3.Computersciencewithpython
bySumitaArora