In this project, you will design, build, and populate a database for the Human Resources (HR) Department at the imaginary Tech ABC Corp, a video game company. This project will start with a request from the HR Manager. From there, you will need to design a database using the foundational principals of data architecture that is best suited to the department's needs. You will go through the steps of database architecture, creating database proposals, database entity relationship diagrams (ERD), and finally creating the database itself. This project is important, as it is a scaled-down simulation of the kind of real-world assignments data architects work on every day.
After many interactions, the proposed solution is as follows:
All content related to this project is in the folder HR-Dataset.
- scripts.sql - File with all the implemented scripts.
- StageTableLoad.sql - Loads file into a staging table
- hr-dataset.xlsx - spreadsheet with all the data
- starter-template.pptx - a slideshow file with the project instructions and guide
- it-best-practises.pdf - further technical instructions and requirements from the client
- Dockerize the Database