Employee Management System (MySQL) A comprehensive relational database project designed to streamline HR operations, automate payroll processing, and provide actionable organizational insights.
📌 Project Overview In modern organizations, managing fragmented employee data, tracking complex salary structures, and monitoring leave patterns can be challenging. This project implements a centralized Employee Management System using MySQL to enhance data integrity and operational efficiency.
🧱 Database Architecture The system is built on a normalized relational structure consisting of 6 core tables:
Employee: Personal and professional records. JobDepartment: Departmental categories and 20+ specific job roles. Payroll: Monthly salary processing records. Salarybonus: Performance-based incentives and bonus tracking. Qualification: Educational and professional certification data. Leaves: Attendance and absence management.
🔍 Key Insights & Reports Through complex SQL queries (Joins, Aggregations, and Subqueries), we extracted the following: Departmental Analysis: The Finance Department has the highest headcount, supporting 9 distinct job roles. Compensation Highlights: Identified the top earners and found that the Legal Department maintains the highest salary allocation. Bonus Distribution: The Finance department receives the highest total bonus amount across the organization. Attendance Patterns: Discovered that January is the peak month for leaves, while July has the highest attendance.
🛠️ Tech Stack Database: MySQL
Tools: MySQL Workbench
Documentation: MS PowerPoint, Excel
👥 Contributors Saraswathi
Pragna Nerella