EMPLOYEE DATA MANAGEMENT

SYSTEM

PROJECT REPORT
Submitted by:
UDHAYAN.B
THARSAN KIRTHIC.K
PRAVIN
KUMAR

THE INDIAN PUBLIC

SCHOOL ERODE 638112
2023-2024
CERTIFICATE
 CERTIFICATE
This is to certify that the project work entitled “EMPLOYEE DATA
MANAGEMENT SYSTEM” is the bonafide record of work done by
UDHAYAN.B Exam No: which is submitted as a partial fulfillment
of the requirement for 12th standard CBSE Board Examination during the academic
year 2023-2024.

Viva voce held on:

Internal Examiner External Examiner

Principal
ACKNOWLEDGEMENT
 ACKNOWLEDGEMENT

First and foremost, I would like to thank my School Management for having
provided me with the facilities required for my project. I extend my heartfelt thanks
and profound gratitude to my Principal, Mr. AtulRunthala for his support during
my project work.
It gives me great pleasure in expressing my gratification to our Academic Director
Mrs. Latha Maheswari and Academics Coordinators Mrs. Radhai shanmugam
and Mr. Nedumaran, for assisting us in doing the work.
I wholeheartedly express my deep sense of indebtedness and appreciation to our
teacher Mr.Sankarnarayanan, Department of computer for his motivation,
guidance and constant encouragement for the successful completion of the task.
I would also like to thank the management employees and trainees of TIPS who
have helped us in preparing this project by providing a lot of crucial information.
I extend my recognitions to all the faculty members of the computer Department for
their support during my project work.
Finally, an honourable mention goes to my family for their understanding and
provision throughout the process of completing the project.

With regards
 CONTENTS

S. No Topic Page No.

1. Synopsis 7

2. Sample code 8

3. Sample screen 14

4. Bibliography 16
 SYNOPSIS
This project has been developed with the complexities involved in manual
preparation of the“EMPLOYEE DATA MANAGEMENT
SYSTEM”overcome by updating it in the computer. The computerized
“EMPLOYEE DATA MANAGEMENT SYSTEM”developed in The Indian
Public School Erode, the computerized
“EMPLOYEE DATA MANAGEMENT SYSTEM” is user friendly and it posses
many features. The data have proved that the result generated by the software are
accurate and has been tested with test data.

This system is divided into six modules :

 In the first module, we can create record of employees.

 In the second module, we can modify the record.

 the third module, we are able to delete record.

 In the fourth module, we are able to search the record.

 In the 5th and 6th module ,we can display the record or stop.
 SAMPLE CODE
import os
import csv
# ADD NEW RECORD
def addrecord():
print('add a new
record')
print('==============')
f=open('employ.csv','a',newline= '\r\n')
s=csv.writer(f)
ID=int(input('Enter ID='))
name=input('Enter name=')
salary=float(input('Enter salary='))
rec=[ID,name,salary]
s.writerow(rec)
f.close()
print('Record Saved')
input('Press any key to continue..')

# MODIFY EXISTINGRECORD
def modifyrecord():
print('Modify a record')
print('==============')
f=open('employ.csv', 'r',newline= '\r\n')
f1=open('temp.csv', 'w',newline= '\r\n')
f1=open('temp.csv', 'a',newline='\r\n')
r=input('enter ID no you want to
modify:') s=csv.reader(f)
s1=csv.writer(f1)
for rec in s:
if rec[0]==r:
print('ID=',rec[0])
print('Name=',rec[1])
print('salary=',rec[2])
choice=input('do you want to modify this record(y/n):')
if choice=='y' or choice=='y':
ID=int(input('Enter new ID='))
name=input('Enter new
name=')
salary=float(input('Enter new salary='))
rec=[ID,name,salary]
s1.writerow(rec)
print('record modified')
break
else:
S1.writerow(rec)
f.close()
f1.close()
 os.remove('employ.csv')
os.rename('temp.csv', 'employ.csv')
input('press any key to continue..')

#DELETE EXISTING RECORD

def deleterecord():
f=open('employ.csv','r',newline='\r\n')
f1=open('temp.csv','w',newline='\r\n')
f1=open('temp.csv','a',newline='\r\n')
r=(input('Enter ID you want to
delete:')) s=csv.reader(f)
s1=csv.writer(f1)
for rec in s:
if rec[0]==r:
print('ID=',rec[0])
print('Name=',rec[1])
print('salary=',rec[2])
choice=input('do you want to delete this record(y/n)')
if choice== 'y' or choice== 'Y':
pass
print('record deleted')
else:
s1.writerow(rec)
f.close()
 f1.close()
os.remove('employ.csv')
os.rename('temp.csv','employ.csv')
input('Press any key to continue..')

# SEARCH EXISTING RECORD

def search():
print('search a record')
print('==================')
f=open('employ.csv','r',newline= '\r\n')#Remove new line character from output
r=input('Enter ID no you want to search:')
s=csv.reader(f)
for rec in s:
if rec[0]==r:
print('ID=',rec[0])
print('Name=',rec[1])
print('salary=',rec[2])
f.close()
input('press any key to
continue..') #VIEW ALL EXISTING
RECORDS
def viewall():
print('list of all
records')
print('=============')
f=open('employ.csv','r',newline= '\r\n')#Remove new line character from output
 s=csv.reader(f)
i=1
for rec in s:
print(rec[0],end= '\t\
t') print(rec[1],end= '\
t\t') print(rec[2])
i=i+1
f.close()
input('press any key to
continue..') #MAIN MENU
def mainmenu():
choice=0
while choice!=6:
print('\n')
print('Main menu')
print('===========')
print('1.Add a new Record')
print('2.Modify Existing
record') print('3.Delete Existing
Record') print('4.Search a
Record')
print('5.List all
Record') print('6.Exit')
choice=int(input('Enter your choice:'))
if choice==1:
 addrecord()
elif choice==2:
modifyrecord()
elif choice==3:
deleterecord()
elif choice==4:
search()
elif choice==5:
viewall()
elif choice==6:
print('software terminated')
break
mainmenu()
SAMPLE SCREEN
Conclusion
Conclusion:
Student Management System can be used by educational institutions to maintain their
student records easily. Achieving this objective is difficult using the manual system as
the information is scattered, can be redundant, and collecting relevant information
may be very time-consuming. All these problems are solved by this project.

This system helps in maintaining the information of pupils of the organization. It can
be easily accessed by the manager and kept safe for a long period of time without any
changes.
Bibliography
BIBLIOGRAPHY:

Source : internet

• www.google.com
• www.w3schools.com
• www.tutorialspoint.com

Books referred

• Class 12 computer science book

(SUMITA ARORA)