This is a simple Employee Management System built using Python and MySQL.
The idea behind this project was to create a small console-based tool that can handle all basic employee management tasks. You can add new employees, view all records, update existing data, and delete records safely. On top of that, it also calculates salary components like PF, HRA, TA, Gross Pay, and Net Pay automatically.
The system comes with a set of useful features:
- Add new employees: Input name, address, contact, email, blood group, and basic pay.
- Automatic salary calculation: Calculates PF, HRA, TA, Gross, and Net pay based on basic salary.
- View all employees: Displays records in a neat table format using BeautifulTable.
- Update employee data: Easily modify employee details when needed.
- Delete records: Delete employees safely with a confirmation prompt.
- User-friendly menu: A simple console menu guides you through all operations.
This project uses a few core technologies:
- Python 3 – the main programming language.
- MySQL – for storing employee records.
- BeautifulTable – for formatted tables in console output.
- mysql-connector-python – for connecting Python with MySQL.
- OS module – to clear the screen for a better menu experience.