Utilized pgAdmin and PostrgreSQL to analyze the database employeesSQL_DB
All files are located in the directory EmployeeSQL
Files:
Utilized https://app.quickdatabasediagrams.com/ to create the ERD diagram: Employee-ERD.png
Schemas: EmployeeSchemas.sql
Queries: EmployeeQueries.sql
The directory outputs contains screen captures of the results of the queries.
ERD:
SCHEMAS (sample: first three):
Query 1 syntax and result in pgAdmin:
