## Departments

DepartmentID | Name
--- | ---
1 | Engineering
2 | Marketing
3 | Human Resources
4 | Finance
5 | IT

## JobTitles

TitleID | Title | MinSalary | MaxSalary
--- | --- | --- | ---
1 | Software Engineer | 70000.0 | 120000.0
2 | Project Manager | 80000.0 | 120000.0
3 | HR Specialist | 60000.0 | 90000.0
4 | Accountant | 55000.0 | 85000.0
5 | System Administrator | 65000.0 | 95000.0

## Employees

EmployeeID | FirstName | LastName | HireDate | Email | PhoneNumber | DepartmentID
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Departments.DepartmentID)
1 | John | Doe | 2021-01-01 | john.doe@example.com | 555-1234 | 1
2 | Jane | Smith | 2021-02-01 | jane.smith@example.com | 555-5678 | 2
3 | Alice | Brown | 2021-03-01 | alice.brown@example.com | 555-9012 | 3
4 | Mike | Johnson | 2021-04-01 | mike.johnson@example.com | 555-1357 | 4
5 | Lisa | Wilson | 2021-05-01 | lisa.wilson@example.com | 555-4321 | 5

## Commissions

CommissionID | Structure
--- | ---
1 | Base Salary Plus Commission
2 | No Base Salary

## SalesReps

SalesRepID | EmployeeID | CommissionID
--- | --- | ---
| (→ Employees.EmployeeID) | (→ Commissions.CommissionID)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 1
4 | 4 | 2
5 | 5 | 1

## MarketingManagers

MarketingManagerID | EmployeeID | CommissionID
--- | --- | ---
| (→ Employees.EmployeeID) | (→ Commissions.CommissionID)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 1
4 | 4 | 2
5 | 5 | 1