Project overview: The company Pewlett-Hackard wants to know the number of employess and the titles.The company also asked us to come up with numbers of elegible mentorship program. Number of retiress, their titles and departments.
QuickDBD, Prostres SQL, PgAdmin 4
CSV files
ERD , diagram was created to get better relationship with primary and foreign keys.
The image shows the current employees.
The image shows data and departments:
The image showing dept emp:
The image shows employess titles:
Different images which are on screenshot folders to shows the tables on pgAdmins
Looking at the datas, the companies has good insight already to recruit new staffs and their train them accordingly with new positions titles. The company was also provided with specific titles per departments. We also provided them the staffs who are elegible for mentorship elegibility.