Visit the Github repo to see the full project & code

Employee Info DB Schema & Querying

Using employee data from a fictional electronics company, I utilized GenMyModel, PostgreSQL, and Python to design, and generate a database, which I then queried and visualized results with Pandas.

Creating ERD & Schema

Using employee data from a fictional electronics company, designed an Entity Relationship Diagram (ERD) conforming to 3rd Normal Form (3NF) and exported the schema using GenMyModel.

Creating Database

Exported schema into SQL file on PostgreSQL server, created tables, imported CSVs, and established relationships.

Creating Database

Completed the following queries using SQL within PostgreSQL

Data Visualization

Exported data into a Pandas DataFrame and created visualizations analylzing the most common salary ranges for employees, and the average salary by title.