Departments

DepartmentIDName
1Engineering
2Marketing
3Human Resources
4Finance
5IT

JobTitles

TitleIDTitleMinSalaryMaxSalary
1Software Engineer70000.0120000.0
2Project Manager80000.0120000.0
3HR Specialist60000.090000.0
4Accountant55000.085000.0
5System Administrator65000.095000.0

Employees

EmployeeIDFirstNameLastNameHireDateEmailPhoneNumberDepartmentID
(→ Departments.DepartmentID)
1JohnDoe2021-01-01john.doe@example.com555-12341
2JaneSmith2021-02-01jane.smith@example.com555-56782
3AliceBrown2021-03-01alice.brown@example.com555-90123
4MikeJohnson2021-04-01mike.johnson@example.com555-13574
5LisaWilson2021-05-01lisa.wilson@example.com555-43215

Commissions

CommissionIDStructure
1Base Salary Plus Commission
2No Base Salary

SalesReps

SalesRepIDEmployeeIDCommissionID
(→ Employees.EmployeeID)(→ Commissions.CommissionID)
111
222
331
442
551

MarketingManagers

MarketingManagerIDEmployeeIDCommissionID
(→ Employees.EmployeeID)(→ Commissions.CommissionID)
111
222
331
442
551