Employee Payroll Management System built using MySQL. This project demonstrates database design, table relationships, and SQL queries for managing employee payroll information.
- departmentp – Stores department details
- employeep – Stores employee information
- salaryp – Stores salary, bonus, and deduction details
- attendencep – Stores employee attendance records
- Manage employee and department data
- Track salary, bonus, and deductions
- Track employee attendance
- Generate payroll reports using SQL queries
- Perform data analysis using JOIN, GROUP BY, and aggregate functions
- MySQL
- SQL
- MySQL Workbench
SELECT e.ename, d.dname, s.sal,
(s.sal + s.bonus - s.deduction) AS total_salary
FROM employeep e
JOIN departmentp d ON e.did = d.did
JOIN salaryp s ON e.eid = s.eid;Ruchita Pethe