ADWAITH THOUGHT ACADEMY
CBSE Affiliation No:1931285
Sowripalayam, Coimbatore–641028
INFORMATICS PRACTICES(065)
PROJECT
2025 – 26
Submitted by
Name: ___________________________
Class: ____________ Sec:___________
Register No: ____________________________
EMPLOYEE MANAGEMENT AND
ANALYTICS SYSTEM
CERTIFICATE
This is to certify that the INFORMATION PRACTICES project on
Employee Management and Analytics System has been successfully
completed by Jeyesh.S and Yuvaraj.J of Class XII, ADWAITH THOUGHT
ACADEMY consideration in partial fulfillment of curriculum of Central
Board of Secondary Education (CBSE) of INFORMATION PRACTICES
for the award of SSCE Practical Examination 2025-26.
I certify that this project is up to my expectation and as per the
guidelines issued by the CBSE.
INTERNAL EXAMINER EXTERNAL EXAMINER
PRINCIPAL
ACKNOWLEDGEMENT
I would like to express my sincere gratitude to my Informatic
Practices teacher Mrs. N. Anitha for her valuable guidance, support,
and expertise throughout this project. Her encouragement and
insights were instrumental in its successful completion
I would also like to thank our respected Principal Mrs.Kumari Padmini
for providing me with the opportunity and resources to work on this
project.
I am deeply grateful to my family for their unwavering support,
motivation, and belief in my abilities, which helped me stay focused
and committed.
My heartfelt thanks to my classmates for their active participation,
collaboration, and encouragement during the course of this project.
Lastly, I sincerely thank everyone who contributed directly or
indirectly to the timely and successful completion of this project
Jeyesh.S
TABEL OF CONTENTS
S.NO DESCRIPTION PAGE.NO
01 INTRODUCTION 6
02 SYSTEM REQUIREMENTS 7
O3 SOURCE CODE 8-14
04 OUTPUT 15-19
05 BIBLIOGRAPHY 20
INTRODUCTION
An Employee Management and Analytics System is a
sophisticated software solution designed to manage
various aspects of employee data and performance
within an organization. It aims to optimize human
resource (HR) operations, improve employee
satisfaction, and provide valuable insights that
contribute to the organization’s success.
The system integrates various modules to streamline
tasks such as recruitment, onboarding, payroll
management, attendance tracking, performance
evaluations, and employee engagement. Additionally,
it leverages data analytics to enhance decision-making,
forecast HR trends, and help managers identify areas
for improvement.
SYSTEM
REQUIREMENTS
HARDWARE REQUIREMENTS
OPERATING SYSTEM : WINDOWS 10 AND ABOVE
PROCESSOR : I3 12th gen or AMD (Ryzen 5 5600G)
MOTHERBOARD :MSI PRO H610ME DDR4 Motherboard
RAM : 8GB
HARD DISK : 512GB
ONITOR 14.1 OR 15-17 INCH
KEYBOARD AND MOUSE
PRINTER : (If print is required -[hard copy])
SOFTWARE REQUIREMENTS
Windows OS 10 or 11
Python version 3.11 or above
Mysql version 8.0
Source code
import mysql.connector
import matplotlib.pyplot as plt
conn = mysql.connector.connect(
host="localhost",
user="root",
password="1234",
database="employee_db")
cursor = conn.cursor()
def add_employee():
emp_id = int(input("Enter Employee ID: "))
name = input("Enter Name: ")
department = input("Enter Department: ")
designation = input("Enter Designation: ")
salary = float(input("Enter Salary: "))
query = "INSERT INTO employees (emp_id, name,
department, designation, salary) VALUES (%s, %s, %s,
%s, %s)"
values = (emp_id, name, department, designation,
salary)
try:
cursor.execute(query, values)
conn.commit()
print("Employee added.\n")
except mysql.connector.errors.IntegrityError:
print("Employee ID already exists.\n")
def view_employees():
cursor.execute("SELECT * FROM employees")
records = cursor.fetchall()
if not records:
print("No employee records found.")
return
print("\n Employee Records:")
print("ID|Name|Dept|Designation|Salary")
print("-" * 60)
for row in records:
print(f"{row[0]:<2} | {row[1]:<14} | {row[2]:<10} |
{row[3]:<16} | ₹{row[4]:.2f}")
print()
def search_employee():
emp_id = int(input("Enter Employee ID to search: "))
cursor.execute("SELECT * FROM employees WHERE
emp_id = %s", (emp_id,))
row = cursor.fetchone()
if row:
print("\n Employee Found:")
print(f"ID : {row[0]}")
print(f"Name : {row[1]}")
print(f"Department : {row[2]}")
print(f"Designation: {row[3]}")
print(f"Salary : ₹{row[4]:.2f}\n")
else:
print("Employee not found.\n")
def delete_employee():
emp_id = int(input("Enter Employee ID to delete: "))
cursor.execute("DELETE FROM employees WHERE
emp_id = %s", (emp_id,))
if cursor.rowcount > 0:
conn.commit()
print("Employee deleted.\n")
else:
print("Employee not found.\n")
def salary_chart():
cursor.execute("SELECT name, salary FROM
employees")
data = cursor.fetchall()
if not data:
print("No data to plot.")
return
names = [row[0] for row in data]
salaries = [row[1] for row in data]
plt.figure(figsize=(10, 5))
plt.bar(names, salaries, color='skyblue')
plt.title("Employee Salary Comparison")
plt.xlabel("Employee Name")
plt.ylabel("Salary (INR)")
plt.xticks(rotation=45)
plt.tight_layout()
plt.show()
def menu():
while True:
print("\n Employee Management System")
print("1. Add Employee")
print("2. View All Employees")
print("3. Search Employee by ID")
print("4. Delete Employee")
print("5. Show Salary Chart")
print("6. Exit")
choice = input("Enter your choice (1–6): ")
if choice == '1':
add_employee()
elif choice == '2':
view_employees()
elif choice == '3':
search_employee()
elif choice == '4':
delete_employee()
elif choice == '5':
salary_chart()
elif choice == '6':
print("Exiting program. Goodbye!")
break
else:
print("Invalid choice. Please try again.")
menu()
conn.close()
Output
Add Employee
View All Employee
Search Employee by ID
Delete employee by ID
Show salary chart
BIBLIOGRAPHY
1) Informatic practices With Python – Class XII By : Sumita
Arora
2) Website :Scribd.Com
