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 |