SQL Payroll System

Employee Payroll Management System built using MySQL. This project demonstrates database design, table relationships, and SQL queries for managing employee payroll information.

📂 Database Tables

• departmentp – Stores department details
• employeep – Stores employee information
• salaryp – Stores salary, bonus, and deduction details
• attendencep – Stores employee attendance records

⚙️ Features

• 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

🛠 Technologies Used

• MySQL
• SQL
• MySQL Workbench

📊 Example Query

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;

📌 Author

Ruchita Pethe