Data Modeling:  Inspected provided CSV files to develop table schemas using pgAdmin or QuickDBD for an Entity Relationship Diagram (ERD).  Data Engineering:  Designed schemas for each CSV file, specifying data types, primary keys, foreign keys, and constraints.  Ensured correct table creation order to manage foreign key dependencies.  Imported data from each CSV file into the corresponding SQL tables in pgAdmin.  Data Analysis:
 Executed SQL Queries

 The SQL queries provided insights into employee demographics, departmental structures, and name distributions, enabling comprehensive analysis of Pewlett Hackard's workforce during the 1980s and 1990s.

 Demonstrates competency in SQL database management, schema design, data importation, and advanced querying techniques for structured data analysis.  Illustrates practical application of relational database skills in real-world scenarios, preparing for roles requiring proficiency in SQL and data manipulation.

 Managing data integrity during CSV importation and ensuring accurate table relationships.  Optimizing SQL queries for performance efficiency, particularly when handling large datasets.  Addressing potential discrepancies or missing data within the CSV files to maintain database consistency.

 Terminal  Postgres  Pgadmin