| DepartmentID | Name |
|---|---|
| 1 | Engineering |
| 2 | Marketing |
| 3 | Human Resources |
| 4 | Finance |
| 5 | IT |
| 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 |
| EmployeeID | FirstName | LastName | HireDate | 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 |
| CommissionID | Structure |
|---|---|
| 1 | Base Salary Plus Commission |
| 2 | No Base Salary |
| SalesRepID | EmployeeID | CommissionID |
|---|---|---|
| (→ Employees.EmployeeID) | (→ Commissions.CommissionID) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 1 |
| 4 | 4 | 2 |
| 5 | 5 | 1 |
| MarketingManagerID | EmployeeID | CommissionID |
|---|---|---|
| (→ Employees.EmployeeID) | (→ Commissions.CommissionID) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 1 |
| 4 | 4 | 2 |
| 5 | 5 | 1 |