SQL-Employee-Database

How to recreate

Create an ERD

• go to quickdatabasediagrams.com to create the diagram
• once finished import into PostgresSQL

Create Tables

• Drag the exported code into the query table
• Run the code to create the tables

Import CSV

• Import each CSV to the tables in order

Create and analysis on the imported information

• List the details of each employee such as employee number, last name, first name, sex, and salary.
• List the first name, last name, and hire date for employees who were hired in 1986.
• List the manager of each department with their department number, department name, the manager's employee number, last name, and first name.
• List the department of each employee with the following information, employee number, last name, and first name, and department name.
• List first name, last name, and sex for employees whose name is "Hercules" and last names begin with "B".
• List all employees in the sales department, including their employee number, last name, first name, and department name.
• List all employees in the sales and development departments, including their employee number, last name, first name, and department name
• List the frequency count of employee last names in descending order.