📘 Employee Management Database Project

From HR Overwhelm to Insightful Clarity

In this project, I set out to create something grounded in the real world—a database system that mirrors the internal workings of a typical company. The result is the Employee Management Database, a fully relational SQL system designed to help organizations manage their employees, departments, and projects with clarity and precision.

🧠 The Challenge

Imagine a mid-sized company managing dozens of employees across various departments, all working on overlapping projects. Without a central system, HR would struggle to answer even the most basic questions:

  • How many employees are in each department?

  • What’s our gender distribution?

  • Who’s earning above £60,000?

  • Are roles and responsibilities balanced?

I wanted to solve this by building a database that could deliver those answers through structured, efficient SQL queries.

🔨 How I Built It

Using MySQL, I built the schema from scratch, normalizing the data into four core tables:

  • Employees

  • Departments

  • Projects

  • Works_On (tracking project involvement and work hours)

I populated the system with 30 employees, 5 departments, and 8 ongoing projects—complete with realistic data like salaries, roles, genders, and hire dates. Referential integrity was enforced through foreign keys to ensure accurate relationships across tables.

📊 Insights Through Data

I then wrote queries to extract insights that HR and management would value, including:

  • Gender Breakdown – Are we inclusive in our hiring?

  • Role Distribution – How is our workforce structured?

  • High Earners by Gender – Who earns more than £60,000, and is the distribution fair?

  • Average Salary by Gender – Are pay gaps present?

These insights transformed a raw dataset into a meaningful story about workplace dynamics.

💡 What I Learned

  • The importance of relational database design in maintaining clean, scalable data.

  • How to write clear and purposeful SQL queries for analysis.

  • That even simulated data, when well-modeled, can reflect real organizational behavior.

🚀 What’s Next?

I plan to expand on this project by creating interactive dashboards using tools like Power BI or Tableau to bring the data to life visually.

✅ Tech Stack

  • Database: MySQL

  • Skills: SQL (DDL, DML, Aggregations, Joins), Data Modeling, Query Optimization, Data Analysis

🔗 Explore the full project on GitHub:

👉 github.com/MikaelSKR/EmployeeManagementSQL

Next

WorldDB SQL Project