HR Database System
This project designs a database management system for HR Operations in PostegreSQL.
Entities
- Employees
- Departments
- Titles
- Salaries
Entity Relations
- Department_Employees
- Employees and the department they belong to
- Department_Managers
- Employees and their managers
ERD
Data
- Randam test data between 1980-2000 is loaded from csv files into tables
Analysis
- Data from postgreSQL in loaded into a Pandas dataframe and then plotted in a bar graph
- It is evident from the graph that on an average, staff get higher salary than managers or engineers, which confirms that the test data is not right