Company SQL Project

This SQL project is designed to manage and retrieve information from a company database named **Company_SD**. It includes queries for employee management, departmental organization, project assignments, and dependent relationships. Below are the key functionalities covered in the queries:

### **Key Functionalities:**

1. **Employee and Dependent Data:**

- Retrieves dependent names based on employee and dependent gender.

- Fetches employees with no dependents.

- Finds employees whose dependents share their first or last names.

2. **Project and Work Assignment Management:**

- Calculates weekly work hours for employees based on project assignments.

- Lists employees working on specific projects.

- Updates salaries for employees working on a project named **"Al Rabwah"**.

3. **Department and Salary Insights:**

- Retrieves department details based on employee relationships.

- Computes average, minimum, and maximum salaries per department.

- Identifies departments with below-average employee salaries.

- Updates department managers and managerial start dates.

4. **Employee Management and Updates:**

- Inserts new employee records into the database.

- Updates supervisor (SuperSSN) details for employees.

- Deletes employees from the database.

- Fetches employees earning an annual salary above a threshold.

- Implements a 20% salary increase for a specific employee.

5. **General Data Retrieval:**

- Lists project names, locations, and department names.

- Retrieves employees’ annual salary calculations.

- Fetches all employees' details and organizes them based on various criteria.

This project serves as a comprehensive database system for a company, ensuring efficient management of employees, departments, and projects while providing detailed analytical insights through SQL queries.