I inspected the CSV files that I obtained for the project, and sketched out an Entity Relationship Diagram (ERD). I used a tool: http://www.quickdatabasediagrams.com, to create the diagram.
- ERD Image
-
I created a table schema for each of the six CSV files with specifying data types, primary keys, foreign keys, and other constraints.
-
Imported each CSV file into the corresponding SQL table using postgreSQL.
-
I listed the following details of each employee: employee number, last name, first name, sex, and salary.
-
I listed first name, last name, and hire date for employees who were hired in 1986.
-
I listed the manager of each department with the following information: department number, department name, the manager's employee number, last name, first name.
-
I listed the department of each employee with the following information: employee number, last name, first name, and department name.
-
I listed first name, last name, and sex for employees whose first name is "Hercules" and last names begin with "B."
-
I listed all employees in the Sales department, including their employee number, last name, first name, and department name.
-
I listed all employees in the Sales and Development departments, including their employee number, last name, first name, and department name.
-
In descending order, I listed the frequency count of employee last names, i.e., how many employees share each last name.
-
I imported the SQL database into Python-Pandas.
-
I created a histogram to visualize the most common salary ranges for the employees.
- Histogram Image
- I created a bar chart of the average salary by job titles.
- Bar Chart Image
Searched ID number: 499942.
- ID 499942 Information
Enjoy!