Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
This project report details the development of an employee management system using python and mysql. It covers the objectives, proposed system, and implementation details, including database connectivity and functions for adding, viewing, updating, deleting, and searching employee records. The report also includes hardware and software requirements, source code snippets, and output screenshots, providing a comprehensive overview of the project's design and functionality. This project aims to apply programming knowledge to real-world situations, develop software using modern tools, and effectively use object-oriented programming principles. The system automates data management, enhancing organizational efficiency and providing a professional appearance. It is designed to store employee information such as name, contact, address, post, and salary, with administrative functions for managing these records.
Typology: Study Guides, Projects, Research
1 / 16
This page cannot be seen from the preview
Don't miss anything!
EMPLOYEE MANAGEMENT SYSTEM
Government Girls Senior Secondary school
Acknowledgment
INTRODUCTION
OBJECTIVES OF THE PROJECT
Files Imported in Project
Flow chart
def view_employees(): query = "SELECT * FROM employee" cursor.execute(query) results = cursor.fetchall() print("\nEmployee Records:") for row in results: print(f"ID: {row[0]}, Name: {row[1]}, Email: {row[2]}, Phone: {row[3]}, Address: {row[4]}, Position: {row[5]}, Salary: {row[6]}") print()
def update_employee(): emp_id = input("Enter Employee ID to update: ") column = input("Enter the column to update (name/email/phone/address/position/salary): ") new_value = input(f"Enter new value for {column}: ") query = f"UPDATE employee SET {column} = %s WHERE emp_id = %s" values = (new_value, emp_id) cursor.execute(query, values) con.commit() print("Employee record updated successfully!")
def delete_employee(): emp_id = input("Enter Employee ID to delete: ") query = "DELETE FROM employee WHERE emp_id = %s" values = (emp_id,) cursor.execute(query, values) con.commit() print("Employee record deleted successfully!")
def search_employee(): emp_id = input("Enter Employee ID to search: ") query = "SELECT * FROM employee WHERE emp_id = %s" values = (emp_id,) cursor.execute(query, values) result = cursor.fetchone() if result: print(f"\nEmployee Details:\nID: {result[0]}, Name: {result[1]}, Email: {result[2]}, Phone: {result[3]}, Address: {result[4]}, Position: {result[5]}, Salary: {result[6]}\n") else: print("Employee not found!")
def menu(): while True: print("\n--- Employee Management System ---") print("1. Add Employee") print("2. View Employees") print("3. Update Employee") print("4. Delete Employee") print("5. Search Employee") print("6. Exit") choice = input("Enter your choice: ") if choice == '1': add_employee() elif choice == '2': view_employees() elif choice == '3': update_employee()
Output Screenshots
Bibliography Google canva Computer science textbook by Sumita arora
