SQL - Employee Database

Data Modeling

Entity Relationship Diagram (ERD) sketch with: http://www.quickdatabasediagrams.com.

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

• 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.