ARWACHIN

International School

COMPUTER SCIENCE
Project File
Academic Year- 2023-2024

Submitted by: Atishay Jain

Class: XII A Atishay Jain

Roll No: 13
Board Roll No :
Subject: Computer Science

Submitted to: Pooja Nemani (PGT CS)

 CERTIFICATE
This is to certify that Atishay Jain of class XII A of
ARWACHIN INTERNATIONAL SCHOOL has
done his project on EMPLOYEE MANAGEMENT
SYSTEM under my supervision. He has taken
interest and has shown at utmost sincerity in
completion of this project.

I certify this project up to my expectation &

as per guidelines issued by CBSE, NEW DELHI.

Internal Examiner Principal

Date External Examiner

ACKNOWLEDGMENT
It is with pleasure that I acknowledge my
sincere gratitude to our teacher, MRS.
POOJA NEMANI who taught and undertook
the responsibility of teaching the subject
computer science. I have greatly benefited
from her classes.

I am especially indebted to our Principal

MRS.DIMPLE PURI who has always been a
source of encouragement and support and
without whose inspiration this project would
not have been successful.
I would like to place on record, heartfelt
thanks to her.

Finally, I would like to express my

appreciation for my parents and friends who
helped me a lot in finishing this project and
supporting me.
 INDEX
1.Background of the project /
Objective
2. Advantage of the project
3. Disadvantage of the project
4. Function and Modules
5. Flow of the project
6.Hardware and Software
requirement
7. Source Code
8. Output
9. Conclusion
10. Bibliography
 OBJECTIVE
The Employee Management System is a strategic
initiative aimed at revolutionizing the traditional
and time-consuming processes involved in
employee information management within an
organization.

Currently, organizations face challenges in

efficiently handling employee data, which often
results in the wastage of valuable resources and
hinders the optimal functioning of the workforce.

In the existing system, tasks such as employee

onboarding, data updates, and performance
monitoring are manual and prone to errors,
leading to inefficiencies in resource utilization.

Our proposed Employee Management System

seeks to address these challenges by automating
and optimizing key HR processes, ultimately
improving the overall productivity and
satisfaction levels of both employees and the
organization.
 NEED FOR EMS
The need of an Employee Management System is to provide an
organized and efficient solution for handling employee-related
information within an organization. Here are the key aspects:

Efficient Information Management:

The primary objective is to efficiently manage and organize employee
information, including details such as names, positions, salaries, and
unique identifiers.

User-Friendly Interface:
The system aims to provide a user-friendly interface for users
(administrators, HR personnel) to interact with the employee data
easily. The command-line menu in the provided code is a simple
example.

Data Accuracy:
The system aims to ensure data accuracy by providing functionalities
like adding, updating, and deleting employee records. This helps in
maintaining up-to-date and accurate information.

Data Persistence:
The system aims to provide data persistence by saving employee data
to a file. This ensures that the information is not lost between program
runs and can be retrieved even after restarting the system.

Real-world Application:
The system addresses a real-world need faced by organizations to
manage their workforce efficiently. It provides a practical solution for
handling employee-related tasks and processes.
 ADVANTAGES
Efficiency:
Automating employee-related tasks increases overall efficiency by
reducing manual effort in managing and organizing information.

Accuracy:
Helps in maintaining accurate and up-to-date employee records,
reducing the chances of errors and data inconsistencies.

Quick Retrieval:
Facilitates quick retrieval of employee information, improving response
times for HR queries and administrative tasks.

Data Security:
Provides a secure environment for storing and managing sensitive
employee data, with access control mechanisms to restrict unauthorized
access.

Financial Monitoring:
Enables effective financial monitoring through features like total salary
calculation, aiding in budgeting and resource allocation.

User-Friendly Interface:
A well-designed and user-friendly interface enhances user experience
and ensures that users can interact with the system easily.

Error Handling:
Robust error-handling mechanisms improve system reliability and
prevent unintended issues, enhancing the overall stability of the system.

Persistence:
The ability to save data to a file ensures persistence between program
runs, preserving data integrity even after system restarts.
 DISADVANTAGES
Dependency on Technology:
Organizations become dependent on technology, and any technical
issues, such as server downtime or software bugs, can disrupt
operations.

Training Requirements:
Users may need training to effectively use the system, especially if
it introduces new interfaces or functionalities.

Data Security Concerns:

Storing sensitive employee information electronically may raise
concerns about data security and the potential for unauthorized
access.

Limited Customization:
Some off-the-shelf solutions may have limitations in
customization, restricting the system's adaptability to unique
organizational requirements.

Data Loss Risks:

Despite measures like saving data to a file, there's always a risk of
data loss due to unforeseen circumstances such as hardware
failures.
 FUNCTIONS
add_employee():
Allows the user to input details for a new employee and
assigns a unique employee ID.
The employee data is then added to the main dictionary.

update_employee():
Takes an employee ID as input and allows the user to
update specific details such as name, position, or salary.

delete_employee():
Removes an employee's record based on their employee
ID.

view_employees():
Prints a tabular view of all employees and their details.

calculate_total_salary():
Calculates and displays the total salary expense for the
company.

save_data_to_file():
Saves the current employee data to a text file for
persistence.

MODULE
MySQL.connector
FLOW OF THE PROJECT
The flow of the Employee Management System project involves a menu-
driven command-line interface that allows users to perform various
operations related to employee management.

Here's a step-by-step breakdown of the project flow:

Connect to MySQL Database:

Establish a connection to a MySQL database using the mysql.connector
module. This connection is necessary for interacting with the employee
data stored in the database.

Create Employee Table (if not exists):

Execute a SQL query to create the "employees" table in the database if it
doesn't already exist. This table stores information such as employee ID,
name, position, and salary.

Main Menu:
Enter into a continuous loop that displays the main menu options for the
Employee Management System.

Menu Options:
The user can choose from the following options:

1. Add Employee:
Accept user input for employee details (name, position, salary).
Execute a SQL query to insert the new employee data into the
"employees" table.
Print a success message.

2. View Employees:
Execute a SQL query to select all records from the "employees" table.
Display a tabular view of all employees and their details.
3. Update Employee Information:
Accept user input for employee ID and the new salary.
Execute a SQL query to update the salary of the specified employee.
Print a success message.

4. Delete Employee:
Accept user input for the employee ID to be deleted.
Execute a SQL query to delete the specified employee record.
Print a success message.

5. Calculate Total Salary:

Execute a SQL query to calculate the total salary expense of the
company.
Print the total salary expense.

6. Save Data to File:

Execute a SQL query to select all records from the "employees" table.
Write the employee data to a text file ("employee_data.txt").
Print a success message.

7. Exit:
Print a goodbye message and exit the program.
If the user enters an invalid choice, an error message is displayed.

The program provides a structured, user-friendly interface for managing

employee information, with options for adding, viewing, updating, and
deleting employee records. It also includes additional features such as
displaying all employees, calculating total salary, and saving data to a
file for persistence. The code is organized into functions for modularity
and readability, and error handling is implemented to manage various
scenarios.

This flow ensures that users can easily navigate the system, perform
necessary tasks, and interact with the employee data stored in the
MySQL database.
HARDWARE AND SOFTWARE
REQUIRED

HARDWARE

SOFTWARE
1.Python (latest version)
2. MySQL
SOURCE CODE
OUTPUT
BIBLIOGRAPHY

1.Computer Science with Python by

Sumita Arora Class XII

2.Google.com

3.Wikipedia.com

4.Youtube.com

5.Programiz.com