SQL Employee Database

Project utilizing SQL to design and manipulate a Database of Employee Information

  • First an ERD diagram (employee_database_design.JPG) was created to sketch the database.
  • Second a Schema (schema.sql) was created to allow for imporation of the CSV files into the PostgresSQL Server.
  • Lastly, SQL queries (queries.sql) were created to manipulate the data to find required data for the HR department.