In this project I was tasked to use Postgre to write sql query statements.
Using QuickDBD, I first created the ERD and then tables. I then imported the schema into Postgre.
There were six small tables in all. I have included the ERD, schema, the query statements, and the csv files holding the data for each table.
Project Instructions:
Data Engineering:
Use the information you have to create a table schema for each of the six CSV files.
- Remember to specify data types, primary keys, foreign keys, and other constraints. Import each CSV file into the corresponding SQL table.
Data Analysis:
Once you have a complete database, do the following:
- List the following details of each employee: employee number, last name, first name, gender, and salary.
- List employees who were hired in 1986.
- List the manager of each department with the following information: department number, department name, the manager's employee number, last name, first name, and start and end employment dates.
- List the department of each employee with the following information: employee number, last name, first name, and department name.
- List all employees whose first 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. In descending order,
- List the frequency count of employee last names, i.e., how many employees share each last name.