KENDRIYA VIDYALAYA NO.

2 ITANAGAR,
ARUNACHAL PRADESH

C.S. PROJECT PORTFOLIO

TOPIC: RESTAURANT MANAGEMENT SYSTEM

SUBMITTED BY SUBMITTED TO
Abu Bakkar Saroj K. Misra Sir
XII A PGT (CS)
Roll no: 18
 CERTIFICATE
This is to certify that ABU BAKKAR, of class XII ‘A’
Kendriya Vidyalaya No.2 Itanagar, Arunachal
Pradesh has done project on RESTAURANT
MANAGEMENT SYSTEM under the supervision of
Saroj K.Misra. I have taken interest and have
shown at most sincerity in completion of this
project.
I certify this project to our expectation and as per
guidelines issued by CBSE, NEW DELHI.

_________________ __________________
Internal Examiner External Examiner

_________________
Principal
 ACKNOWLEDGEMENT
It is my 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 greatly benefited
from his classes.
I would like to express my sincere
appreciation for all the other students of
my batch and their fine times that we all
shared together.
Finally, I would like to thank our principal
K.R. Meena who has always been a source
of inspiration.
 HARDWARE AND SOFTWARE
REQUIRED

● HARDWARE
PC
MOBILE PHONE

● SOFTWARE
PYTHON (latest version)
MYSql Python Connector
CODING
 DATABASE
# MENU SECTION
# DETAILS OF THE CUSTOMER

# FEEDBACK FROM CUSTOMER

 OUTPUT

# WELCOME PAGE AND VIEWING MENU

# ORDERING AN ITEM

# FOR VIEWING YOUR ORDERS

# FOR CANCELLING AN ORDER

# FEEDBACK FROM CUSTOMER

1 / 21
2 / 21
3 / 21
4 / 21
5 / 21
Python Code:

import os
import platform
import mysql.connector
#import pandas as pd
#from pandas import DataFrame

def selection():
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
print('-----------------------------------\nWELCOME TO SCHOOL MANAGEMENT SYSTEM\n-----------------------------------')
print("1.STUDENT MANAGEMENT")
print("2.EMPLOYEE MANAGEMENT")
print("3.FEE MANAGEMENT")
print("4.EXAM MANAGEMENT")

ch=int(input("\nEnter ur choice (1-4) : "))

if ch==1:
print('\nWELCOME TO STUDENT MANAGEMENT SYSTEM\n')
print('a.NEW ADMISSION')
print('b.UPDATE STUDENT DETAILS')
print('c.ISSUE TC')
c=input("Enter ur choice (a-c) : ")
print('\nInitially the details are..\n')
display1()
if c=='a':
insert1()
print('\nModified details are..\n')
display1()
elif c=='b':
update1()
print('\nModified details are..\n')
display1()
elif c=='c':
delete1()
print('\nModified details are..\n')
display1()
else:
print('Enter correct choice...!!')
elif ch==2:
print('WELCOME TO EMPLOYEE MANAGEMENT SYSTEM')
print('a.NEW EMPLOYEE')
print('b.UPDATE STAFF DETAILS')
print('c.DELETE EMPLOYEE')
c=input("Enter ur choice : ")
if c=='a':
insert2()

6 / 21
 print('\nModified details are..\n')
display2()
elif c=='b':
update2()
print('\nModified details are..\n')
display2()
elif c=='c':
delete2()
print('\nModified details are..\n')
display2()
else:
print('Enter correct choice...!!')
elif ch==3:
print('WELCOME TO FEE MANAGEMENT SYSTEM')
print('a.NEW FEE')
print('b.UPDATE FEE')
print('c.EXEMPT FEE')
c=input("Enter ur choice : ")
if c=='a':
insert3()
elif c=='b':
update3()
elif c=='c':
delete3()
else:
print('Enter correct choice...!!')
elif ch==4:
print('WELCOME TO EXAM MANAGEMENT SYSTEM')
print('a.EXAM DETAILS')
print('b.UPDATE DETAILS ')
print('c.DELETE DETAILS')
c=input("Enter ur choice : ")
if c=='a':
insert4()
elif c=='b':
update4()
elif c=='c':
delete4()
else:
print('Enter correct choice...!!')
else:
print('Enter correct choice..!!')

def insert1():
sname=input("Enter Student Name : ")
admno=int(input("Enter Admission No : "))
dob=input("Enter Date of Birth(yyyy-mm-dd): ")
cls=input("Enter class for admission: ")
cty=input("Enter City : ")
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()

7 / 21
 sql="INSERT INTO student(sname,admno,dob,cls,cty) VALUES ( '%s' ,'%d','%s','%s','%s')"%(sname,admno,dob,cls,cty)
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
db.close()
#insert()

def display1():
try:
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql = "SELECT * FROM student"
cursor.execute(sql)
results = cursor.fetchall()
for c in results:
sname = c[0]
admno= c[1]
dob=c[2]
cls=c[3]
cty=c[4]
print ("(sname=%s,admno=%d,dob=%s,cls=%s,cty=%s)" % (sname,admno,dob,cls,cty))
except:
print ("Error: unable to fetch data")
db.close()
def update1():
try:
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql = "SELECT * FROM student"
cursor.execute(sql)
results = cursor.fetchall()

for c in results:
sname = c[0]
admno= c[1]
dob=c[2]
cls=c[3]
cty=c[4]
except:
print ("Error: unable to fetch data")
print()
tempst=int(input("Enter Admission No : "))
temp=input("Enter new class : ")
try:
sql = "Update student set cls=%s where admno='%d'" % (temp,tempst)
cursor.execute(sql)
db.commit()
except Exception as e:
print (e)

8 / 21
 db.close()
def delete1():
try:
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql = "SELECT * FROM student"
cursor.execute(sql)
results = cursor.fetchall()
for c in results:
sname = c[0]
admno= c[1]
dob=c[2]
cls=c[3]
cty=c[4]
except:
print ("Error: unable to fetch data")

temp=int(input("\nEnter adm no to be deleted : "))

try:
sql = "delete from student where admno='%d'" % (temp)
ans=input("Are you sure you want to delete the record(y/n) : ")
if ans=='y' or ans=='Y':
cursor.execute(sql)
db.commit()
except Exception as e:
print (e)
db.close()
def insert2():
ename=input("Enter Employee Name : ")
empno=int(input("Enter Employee No : "))
job=input("Enter Designation: ")
hiredate=input("Enter date of joining: ")
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql="INSERT INTO emp(ename,empno,job,hiredate) VALUES ( '%s' ,'%d','%s','%s')"%(ename,empno,job,hiredate)
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
db.close()
def display2():
try:
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql = "SELECT * FROM emp"
cursor.execute(sql)
results = cursor.fetchall()
for c in results:
ename = c[0]
empno= c[1]

9 / 21
 job=c[2]
hiredate=c[3]
print ("(empno=%d,ename=%s,job=%s,hiredate=%s)" % (empno,ename,job,hiredate))
except:
print ("Error: unable to fetch data")
db.close()
def update2():
try:
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql = "SELECT * FROM emp"
cursor.execute(sql)
results = cursor.fetchall()
for c in results:
ename = c[0]
empno= c[1]
job=c[2]
hiredate=c[3]
except:
print ("Error: unable to fetch data")
print()
tempst=int(input("Enter Employee No : "))
temp=input("Enter new designation : ")
try:
sql = "Update emp set job=%s where empno='%d'" % (temp,tempst)
cursor.execute(sql)
db.commit()
except Exception as e:
print (e)
db.close()
def delete2():
try:
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql = "SELECT * FROM emp"
cursor.execute(sql)
results = cursor.fetchall()
for c in results:
ename = c[0]
empno= c[1]
job=c[2]
hiredate=c[3]
except:
print ("Error: unable to fetch data")

temp=int(input("\nEnter emp no to be deleted : "))

try:
sql = "delete from emp where empno='%d'" % (temp)
ans=input("Are you sure you want to delete the record(y/n) : ")
if ans=='y' or ans=='Y':
cursor.execute(sql)

10 / 21
 db.commit()
except Exception as e:
print (e)
db.close()
def insert3():
admno=int(input("Enter adm no: "))
fee=float(input("Enter fee amount : "))
month=input("Enter Month: ")
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql="INSERT INTO fee(admno,fee,month) VALUES ( '%d','%d','%s')"%(admno,fee,month)
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
db.close()
def display3():
try:
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql = "SELECT * FROM fee"
cursor.execute(sql)
results = cursor.fetchall()
for c in results:
admno= c[0]
fee=c[1]
month=c[2]
print ("(admno=%d,fee=%s,month=%s)" % (admno,fee,month))
except:
print ("Error: unable to fetch data")
db.close()
def update3():
try:
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql = "SELECT * FROM fee"
cursor.execute(sql)
results = cursor.fetchall()
for c in results:
admno= c[0]
fee=c[1]
month=c[2]
except:
print ("Error: unable to fetch data")
print()
tempst=int(input("Enter Admission No : "))
temp=input("Enter new class : ")
try:
sql = "Update fee set month=%s where admno='%d'" % (temp,tempst)
cursor.execute(sql)

11 / 21
 db.commit()
except Exception as e:
print (e)
db.close()
def delete3():
try:
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql = "SELECT * FROM fee"
cursor.execute(sql)
results = cursor.fetchall()
for c in results:
admno= c[0]
fee=c[1]
month=c[2]
except:
print ("Error: unable to fetch data")

temp=int(input("\nEnter adm no to be deleted : "))

try:
sql = "delete from student where admno='%d'" % (temp)
ans=input("Are you sure you want to delete the record(y/n) : ")
if ans=='y' or ans=='Y':
cursor.execute(sql)
db.commit()
except Exception as e:
print (e)
db.close()
def insert4():
sname=input("Enter Student Name : ")
admno=int(input("Enter Admission No : "))
per=float(input("Enter percentage : "))
res=input("Enter result: ")
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql="INSERT INTO exam(sname,admno,per,res) VALUES ( '%s' ,'%d','%s','%s')"%(sname,admno,per,res)
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
db.close()
def display4():
try:
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql = "SELECT * FROM exam"
cursor.execute(sql)
results = cursor.fetchall()
for c in results:
sname = c[0]

12 / 21
 admno= c[1]
dob=c[2]
cls=c[3]
cty=c[4]
print ("(sname,admno,per,res)"%(sname,admno,per,res) )
except:
print ("Error: unable to fetch data")
db.close()

def update4():
try:
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql = "SELECT * FROM exam"
cursor.execute(sql)
results = cursor.fetchall()

for c in results:
sname = c[0]
admno= c[1]
dob=c[2]
cls=c[3]
cty=c[4]
except:
print ("Error: unable to fetch data")
print()
tempst=int(input("Enter Admission No : "))
temp=input("Enter new result : ")
try:
sql = "Update student set res=%s where admno='%d'" % (temp,tempst)
cursor.execute(sql)
db.commit()
except Exception as e:
print (e)
db.close()
def delete4():
try:
db = mysql.connector.connect(user='root', password='tiger', host='localhost',database='mysql')
cursor = db.cursor()
sql = "SELECT * FROM exam"
cursor.execute(sql)
results = cursor.fetchall()
for c in results:
sname = c[0]
admno= c[1]
dob=c[2]
cls=c[3]
cty=c[4]
except:
print ("Error: unable to fetch data")

13 / 21
 temp=int(input("\nEnter adm no to be deleted : "))
try:
sql = "delete from exam where admno='%d'" % (temp)
ans=input("Are you sure you want to delete the record(y/n) : ")
if ans=='y' or ans=='Y':
cursor.execute(sql)
db.commit()
except Exception as e:
print (e)
db.close()
selection()

14 / 21
PROJECT TITLE- “SCHOOL MANAGEMENT”

DBMS: MySQL
Host : localhost
User: root
Password: tiger
DataBase: mysql
Table Structure: As per the Screenshot given below:

Table:Student

Table: Emp

15 / 21
Table:Fee

Table:Exam

16 / 21
 OUTPUT:

INSERT DETAILS

17 / 21
UPDATE DETAILS

18 / 21
DELETE DETAILS

By:
Shivkamal Singh (PGT CS)
KV Sehore

19 / 21
20 / 21
21 / 21