UCF_Boot_Camp_SQL_9 This project involves three main tasks: Data Modeling, Data Engineering, and Data Analysis. The goal is to create a structured database from given CSV files, analyze the data, and derive meaningful insights.

Data Modeling Entity Relationship Diagram (ERD):

Inspect the CSV files to understand the data structure and relationships.

Use a tool like QuickDBD to sketch the ERD, visualizing the relationships between tables.

Data Engineering Table Schema Creation:

Create a table schema for each of the six CSV files.

Ensure to specify data types, primary keys, foreign keys, and other constraints.

Verify the primary keys for uniqueness. If necessary, create composite keys.

Table Creation Order:

Create tables in the correct order to handle foreign key constraints properly.

Import Data:

Import the data from each CSV file into its corresponding SQL table.

Data Analysis Employee Details:

List the employee number, last name, first name, sex, and salary of each employee.

Employees Hired in 1986:

List the first name, last name, and hire date for employees hired in 1986.

Department Managers:

List the manager of each department, including their department number, department name, employee number, last name, and first name.

Employee Departments:

List each employee’s department number along with their employee number, last name, first name, and department name.

Specific Employee Search:

List the first name, last name, and sex of employees named Hercules whose last name starts with B.

Sales Department Employees:

List employees in the Sales department, including their employee number, last name, and first name.

Sales and Development Employees:

List employees in the Sales and Development departments, including their employee number, last name, first name, and department name.

Frequency of Last Names: