Departments:

DepartmentID $($Primary Key$)$

DepartmentName

DepartmentNumber

ManagerID $($Foreign Key referencing EmployeeID$)$

StartDate

Employees:

EmployeeID $($Primary Key$)$

Name

SSN

Address

Salary

Gender

Birthdate

DepartmentID $($Foreign Key referencing DepartmentID$)$

SupervisorID $($Foreign Key referencing EmployeeID$)$

Projects:

ProjectID $($Primary Key$)$

ProjectName

ProjectNumber

Location

DepartmentID $($Foreign Key referencing DepartmentID$)$

HoursWorked:

EmployeeID $($Composite Foreign Key referencing EmployeeID$)$

ProjectID $($Composite Foreign Key referencing ProjectID$)$

HoursPerWeek

Dependents:

DependentID $($Primary Key$)$

EmployeeID $($Foreign Key referencing EmployeeID$)$

Name

Gender

Birthdate

Relationship

In this structure:

The DepartmentID in the Employees table links an employee to a specific department.

The ManagerID in the Departments table designates the manager of a department, linking to an employee in the Employees table.

The SupervisorID in the Employees table designates the direct supervisor of an employee, linking to another employee in the same table.

The DepartmentID in the Projects table associates a project with a particular department.

The EmployeeID and ProjectID in the HoursWorked table create a many$-$to$-$many relationship between employees and projects, allowing an employee to work on multiple projects, and a project to have multiple employees.

The EmployeeID in the Dependents table associates a dependent with a specific employee.