HR Database System (Microsoft SQL Server)

This project is about the HR data for a company by modeling the database using ERD and implementing the database into Microsoft SQL Server.

This Dataset is from the HR Department for all Employees of the company even the ones that left(Attrition). The data collection started from 2012 until 2022. Our quest was to build a database for this company that can be used for the following business needs.

There are plenty of details to have about the Employee: Their ID, Name, Gender, Age, Department in which they work, Their hire date, their Salary, Job role, Whether they work overtime or not, whether they travel for business or not, and whether they are still in the company or left.

We also need to keep the educational background of each employee, their educational level and the field of said education.

We also need to keep track of the employee’s history like when was their last promotion, how many years have they worked for the company, how many years have they worked with the same manager, and how many years have they spent in their current role.

We also need to keep track of how many departments we have and what they are.

Annually, each employee gets to have a review with the HR and their direct manager, during this review the employee fills out a survey where they give a satisfaction rate of 1-5 for how satisfied they are with their job, the environment, their relationships with colleagues and their work-life balance. They also give themselves a rate of 1-5 for how they feel their performance was in the previous year. While their managers also give a rating of 1-5 for the employee's performance in the previous year.