## Departments

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

## Employees

EmployeeID | FirstName | LastName | Email | PhoneNumber | HireDate | Salary | DepartmentID
--- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  |  | (→ Departments.DepartmentID)
1 | John | Doe | john.doe@example.com | 123-456-7890 | 2020-01-01 | 60000.0 | 1
2 | Jane | Smith | jane.smith@example.com | 987-654-3210 | 2019-02-01 | 50000.0 | 2
3 | Alice | Brown | alice.brown@example.com | 456-789-0123 | 2018-03-01 | 55000.0 | 3
4 | Bob | White | bob.white@example.com | 246-865-1357 | 2017-04-01 | 65000.0 | 4
5 | Charlie | Black | charlie.black@example.com | 654-321-0987 | 2016-05-01 | 70000.0 | 5

## WorkingArrangements

ArrangementID | Description
--- | ---
1 | Remote
2 | Onsite
3 | Hybrid
4 | Flexible
5 | Rotational

## Positions

PositionID | Title | MinimumQualifications | MaximumSalary | MINumberOfYearsExperience | ForeignKey_PositionType
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ PositionTypes.PositionTypeID)
1 | Software Engineer | Bachelor's degree in Computer Science | 100000.0 | 2 | 1
2 | Data Analyst | Bachelor's degree in Mathematics or Statistics | 80000.0 | 2 | 2
3 | Product Manager | MBA or equivalent experience | 120000.0 | 4 | 3
4 | UX Designer | Bachelor's degree in Graphic Design or Interaction Design | 90000.0 | 3 | 4
5 | HR Generalist | Bachelor's degree in Human Resources | 60000.0 | 2 | 5

## JobPostings

JobID | PositionID | CompanyId | OpeningDate | ClosingDate | Description | Location | ApplicationInstructions | RequisitionNumber | IsActive
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
| (→ Positions.PositionID) | (→ Companies.CompanyId) |  |  |  |  |  |  |
1 | 1 | 1 | 2021-01-01 | 2021-12-31 | Seeking a software engineer... | New York | Apply online at our website. | REQ12345 | 1
2 | 2 | 2 | 2021-02-01 | 2021-12-31 | Looking for an experienced product manager... | San Francisco | Submit resume and cover letter via email. | REQ67890 | 1
3 | 3 | 3 | 2021-03-01 | 2021-12-31 | We are hiring a UX designer... | Los Angeles | Apply through our careers portal. | REQ13579 | 1
4 | 4 | 4 | 2021-04-01 | 2021-12-31 | A HR generalist is needed for our team... | Chicago | Email resume to hr@company.com. | REQ24680 | 1
5 | 5 | 5 | 2021-05-01 | 2021-12-31 | Join us as a data analyst... | Dallas | Complete this form on our website. | REQ36901 | 1

## SalesManagers

ManagerID | EmployeeID | DepartmentID
--- | --- | ---
| (→ Employees.EmployeeID) | (→ Departments.DepartmentID)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 1
4 | 4 | 2
5 | 5 | 1

## MarketingSpecialists

SpecialistID | EmployeeID | DepartmentID
--- | --- | ---
| (→ Employees.EmployeeID) | (→ Departments.DepartmentID)
1 | 1 | 3
2 | 2 | 4
3 | 3 | 3
4 | 4 | 4
5 | 5 | 3

## EmploymentArrangements

EmpArrangementID | EmployeeID | ArrangementID | StartDate | EndDate
--- | --- | --- | --- | ---
| (→ Employees.EmployeeID) | (→ WorkingArrangements.ArrangementID) |  |
1 | 1 | 1 | 2020-06-01 | 2022-06-01
2 | 2 | 2 | 2019-07-01 | 2021-07-01
3 | 3 | 3 | 2018-08-01 | 2020-08-01
4 | 4 | 4 | 2017-09-01 | 2019-09-01
5 | 5 | 5 | 2016-10-01 | 2018-10-01