Background It’s been two weeks since you were hired as a new data engineer at Pewlett Hackard (a fictional company). Your first major task is to do a research project about people whom the company employed during the 1980s and 1990s. All that remains of the employee database from that period are six CSV files.
For this project, you’ll design the tables to hold the data from the CSV files, import the CSV files into a SQL database, and then answer questions about the data. That is, you’ll perform data modeling, data engineering, and data analysis, respectively.
Opened the excel files and looked at the data and columns to make the ERD diagram using quick DBD. Went over the module #9 activities to get the primary and foreign keys down. I did my employ info in a vscode.sql file, it was easier to write out instead of using postgres. I did do a breakout group with some classmates on a day for getting some of this done.