r. Sec.
Public
P. S Sc
hoo
R. R.
l
Kanpur Road, Fatehgarh
Session: 2025-26
Class: XII
Subject: Computer Science (083)
Project File
Topic: Employee Management System
Submitted by:
Submitted to: Name:………………………….
.RollNo:………………..........
Mr. Mahesh Pratap Singh
Teacher’s Signature Principal’s Signature Examiner’s Signature
Index
➢ Certificate
➢ Acknowledgement
➢ Coding
➢ Output
➢ Bibliography
Certificate
This is to certify that
___________________________ of Class: XII,
R.R.P. Sr. Sec. Public School, Kanpur Road
Fatehgarh has completed his/her project in
Computer Science (083) for the AISSCE as
prescribed by CBSE in the year 2025-26.
Date: ______________
Signature of Examiner Teacher’s Signature
____________________ __________________
ACKNOWLEDGEMENT
I would like to express my special thank of gratitude
to our teacher Mr. Mahesh Pratap Singh as well as
our principal Ma'am Sudha Mishra, who gave us the
opportunity to make this project on the topic
"Employee Management System",
which also helped me in doing lots of research I came
to know about many new things so I am very thankful
to them.
Secondly, I would like to thank my parents and
friends who helped me in making this project in
limited frame of time.
Date: _______________
Coding:
import [Link] as em
import csv
con=[Link](host="localhost",user='root',password='School@123',database='emp')
cursor=[Link]()
def design():
print("* *"*20 )
def registration():
print("* *"*5,"Registration Form","* *"*5)
design()
name=input("Enter employee name:")
design()
fname=input("Enter father's name:")
design()
mname=input("Enter mother's name:")
design()
dob=input("Enter dob:")
design()
print("Press 1 for master degree")
print("Press 2 for graduate degree")
print("Press 3 for under graduate")
design()
ch=int(input("Enter your choice"))
design()
if ch==1:
qlf='Master'
print("Press 1 for MTech")
print("Press 2 for MSc-Bio")
print("Press 3 for MSc-Maths")
print("Press 4 for MBA")
print("Press 5 for MCOM")
print("Press 6 for MA-English")
print("Press 7 for MA-Honour")
print("Press 8 for MA-Political Science")
print("Press 9 for other")
design()
ch=int(input("Enter your choice"))
design()
if ch==1:
degree='Mtech'
elif ch==2:
degree='Msc-Bio'
elif ch==3:
degree='Msc-Maths'
elif ch==4:
degree='MBA'
elif ch==5:
degree='MCOM'
elif ch==6:
degree='MA-English'
elif ch==7:
degree=='MA-Honour'
elif ch==8:
degree='MA-Political Science'
else:
design()
degree=input("Enter Degree Name")
design()
elif ch==2:
qlf='Graduate'
print("Press 1 for BTech")
print("Press 2 for BSc-Bio")
print("Press 3 for BSc-Maths")
print("Press 4 for BBA")
print("Press 5 for BCOM")
print("Press 6 for BA-English")
print("Press 7 for BA-Honour")
print("Press 8 for BA-Political Science")
print("Press 9 for other")
design()
ch=int(input("Enter your choice"))
design()
if ch==1:
degree='Btech'
elif ch==2:
degree='Bsc-Bio'
elif ch==3:
degree='Bsc-Maths'
elif ch==4:
degree='BBA'
elif ch==5:
degree='BCOM'
elif ch==6:
degree='BA-English'
elif ch==7:
degree=='BA-Honour'
elif ch==8:
degree='BA-Political Science'
else:
design()
degree=input("Enter The Degree Name")
elif ch==3:
degree='Under graduate'
qlf='10+2'
else:
degree='NA'
qlf='NA'
#degree=input("Enter the degree name")
#spk=input("Enter special skill if any")
print("Press 1 for Computer Skills")
print("Press 2 for Dance Skills")
print("Press 3 for Music Skills")
print("Press 4 for Singing Skills")
print("Press 5 for other")
design()
ch=int(input("Enter your choice"))
design()
if ch==1:
spk='Computer Skills'
elif ch==2:
spk='Dance Skills'
elif ch==3:
spk='Music Skills'
elif ch==4:
spk='Singing Skills'
else:
design()
spk=input("Enter The name of special skills")
design()
spc=input("Enter certificate/diploma if any" )
design()
address=input("Enter address")
design()
contactno=input("Enter contact number")
design()
gender=input("Press M for Male or F for female")
design()
email=input("Enter email id")
design()
exp=int(input("Enter experience"))
design()
cmd="insert into
registration_employee(name,Fathers_name,mothers_name,dob,qualification,degree,special_skill,spe
cial_certificate,address,contact_no,gender,email_id,experience)
values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s',%s)"
%(name,fname,mname,dob,qlf,degree,spk,spc,address,contactno,gender,email,exp)
[Link](cmd)
[Link]()
design()
design()
print("New record has been added")
design()
def Update():
print("* *"*10,"Registration Form Correction Window","* *"*10)
design()
customer_id = int(input("Enter customer id:"))
design()
cmd='select name from registration_employee where Employment_id=%s'%(customer_id)
[Link](cmd)
d=[Link]()
if not d:
print("Record not found Please retry")
Update()
design()
print("Employee Name:",d[0])
[Link]("desc registration_employee")
v=[Link]()
for i in range(1,len(v)):
if i>4 and i<8:
continue
print("Press ",i,"to change",v[i][0])
design()
ch=int(input("Enter your choice"))
if ch==1:
design()
name=input("Enter correct name")
design()
cmd="Update registration_employee set name = '%s' where employment_id =
%s"%(name,customer_id)
[Link](cmd)
[Link]()
design()
print("The details have been updated successfully")
design()
elif ch==2:
design()
fname=input("Enter correct Father's name")
design()
cmd="Update registration_employee set fathers_name = '%s' where employment_id =
%s"%(fname,customer_id)
[Link](cmd)
[Link]()
design()
print("The details have been updated successfully")
design()
elif ch==3:
design()
mname=input("Enter correct mother's name")
design()
cmd="Update registration_employee set mothers_name = '%s' where employment_id =
%s"%(mname,customer_id)
[Link](cmd)
[Link]()
design()
print("The details have been updated successfully")
design()
elif ch==4:
design()
a=input("Enter correct dob")
design()
cmd="Update registration_employee set dob = '%s' where employment_id =
%s"%(a,customer_id)
[Link](cmd)
[Link]()
design()
print("The details have been updated successfully")
design()
elif ch==12:
design()
d=input("Enter correct degree")
design()
cmd="Update registration_employee set degree = '%s' where employment_id =
%s"%(d,customer_id)
[Link](cmd)
[Link]()
design()
print("The details have been updated successfully")
design()
elif ch==8:
design()
ad=input("Enter correct Address")
design()
cmd="Update registration_employee set address = '%s' where employment_id =
%s"%(ad,customer_id)
[Link](cmd)
[Link]()
design()
print("The details have been updated successfully")
design()
elif ch==13:
design()
exp=input("Update experience")
design()
cmd="Update registration_employee set experience = %s where employment_id =
%s"%(exp,customer_id)
[Link](cmd)
[Link]()
design()
print("The details have been updated successfully")
design()
elif ch==11:
design()
exp=input("Update emailid")
design()
cmd="Update registration_employee set email_id = '%s' where employment_id =
%s"%(exp,customer_id)
[Link](cmd)
[Link]()
design()
print("The details have been updated successfully")
design()
#def Search():
#registration()
def Search():
print("* *"*10,"Search Window","* *"*10)
design()
#q=input("Enter qualification")
cmd='select distinct(qualification) from registration_employee'
[Link](cmd)
data=[Link]()
design()
print("Select the qualification")
design()
L=[]
for i in range(len(data)):
print(data[i][0].capitalize())
[Link](data[i][0].lower())
design()
ch=input("Enter your choice")
design()
ch=[Link]()
if ch not in L:
design()
print("Please reselect your choice")
design()
Search()
cmd='select distinct(degree) from registration_employee'
[Link](cmd)
data=[Link]()
L=[]
design()
print("Select the degree")
design()
for i in range(len(data)):
print(data[i][0].capitalize())
[Link](data[i][0].lower())
design()
ch1=input("Enter your choice")
design()
ch1=[Link]()
if ch1 not in L:
design()
print("Please reselect your choice")
Search()
design()
exp=int(input("How much experience person do you want?"))
design()
cmd="select name,qualification,degree,contact_no,email_id from registration_employee where
qualification='%s' and degree='%s' and experience>=%s"%(ch,ch1,exp)
[Link](cmd)
data=[Link]()
print("Name\tQualification\tDegree\tContact_no\t,email\t")
for d in data:
#print(d)
n,q,d,c,e=d
design()
print(n,'\t',q,'\t\t',d,'\t',c,'\t',e)
design()
def Remove():
design()
name=input("Enter Name")
design()
cmd="select employment_id,name from registration_employee where name='%s' "%(name)
[Link](cmd)
d=[Link]()
design()
print('id\tName')
for i in d:
print(i[0],'\t',i[1])
design()
id=int(input("Enter id whose record to be deleted"))
cmd='delete from registration_employee where employment_id=%s '%(id)
[Link](cmd)
[Link]()
print('Done')
def Myfile():
o=open("[Link]","w")
wr=[Link](o)
line=('Empid','Name',"Father's Name","Mother's Name",'DOB',"Qualification","Special
Skill","Special Certificate","Address","Contact No","Gender","Email ID","Degree",'Experience')
cmd="select * from registration_employee"
[Link](cmd)
[Link](line)
data=[Link]()
for i in data:
[Link](i)
[Link]()
while True:
print("*"*10,"Welcome to Employment Management System Application.",'*'*10)
print("Press 1 For Adding New")
print("Press 2 For Updateing")
print("Press 3 For Searching records")
print("Press 4 For Removing ")
print("Press 5 for creating excel file")
ch=int(input("Enter your choice"))
if ch==1:
registration()
elif ch==2:
Update()
elif ch==3:
Search()
elif ch==4:
Remove()
elif ch==5:
Myfile()
else:
print("THANK YOU FOR USING .")
break
Output
Database Table:
Data of registration_employee Table:
Bibliography
oComputer Science by Sumita Arora
[Link]