Overview

This project involves managing relational data for employees, including their departments and roles. Below is a breakdown of the project structure and file locations.

Project Structure

/EmployeeSQL
├── ERD_IMAGE.png # ERD image
├── table_schemata.sql # SQL for table schemata
├── Q1_SQL-query.sql # Employee counts query
├── Q2_SQL-query.sql # Sales department employees
├── Q3_SQL-query.sql # Development department employees
├── Q4_SQL-query.sql # Employees named Hercules
├── Q5_SQL-query.sql # Last name frequency counts
├── Q6_SQL-query.sql # Employees by department
├── Q7_SQL-query.sql # Department managers info
├── Q8_SQL-query.sql # Detailed employee info
├── /analysis-exports
│ └── data-analysis_Q1.csv # SQL Output
│ └── data-analysis_Q1.png # SQL image
│ └── data-analysis_Q2.csv # SQL Output
│ └── data-analysis_Q2.png # SQL image
│ └── data-analysis_Q3.csv # SQL Output
│ └── data-analysis_Q3.png # SQL image
│ └── data-analysis_Q4.csv # SQL Output
│ └── data-analysis_Q4.png # SQL image
│ └── data-analysis_Q5.csv # SQL Output
│ └── data-analysis_Q5.png # SQL image
│ └── data-analysis_Q6.csv # SQL Output
│ └── data-analysis_Q6.png # SQL image
│ └── data-analysis_Q7.csv # SQL Output
│ └── data-analysis_Q7.png # SQL image
│ └── data-analysis_Q8.csv # SQL Output
│ └── data-analysis_Q8.png # SQL image
├── /data
│ └── departments.csv # Supporting CSV Data File
│ └── dept_emp.csv # Supporting CSV Data File
│ └── dept_manager.csv # Supporting CSV Data File
│ └── employees.csv # Supporting CSV Data File
│ └── salaries.csv # Supporting CSV Data File
│ └── titles.csv # Supporting CSV Data File
└── README.md # This README file

File Descriptions

• ERD_IMAGE.png: Visual representation of the database structure.
• table_schemata.sql: SQL script defining the table schemas.
• Q1-Q8 SQL query files: Each file contains SQL code for specific queries, focusing on different aspects of employee and department data.
• /analysis-exports: Folder containing CSV output data and visualizations for each SQL query.
• /data: Folder containing supporting CSV files that feed into the SQL queries.