| DepartmentID | Name |
|---|---|
| 1 | Human Resources |
| 2 | IT |
| 3 | Finance |
| 4 | Marketing |
| 5 | Sales |
| EmployeeID | FirstName | LastName | 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 |
| ArrangementID | Description |
|---|---|
| 1 | Remote |
| 2 | Onsite |
| 3 | Hybrid |
| 4 | Flexible |
| 5 | Rotational |
| 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 |
| 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 |
| ManagerID | EmployeeID | DepartmentID |
|---|---|---|
| (→ Employees.EmployeeID) | (→ Departments.DepartmentID) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 1 |
| 4 | 4 | 2 |
| 5 | 5 | 1 |
| SpecialistID | EmployeeID | DepartmentID |
|---|---|---|
| (→ Employees.EmployeeID) | (→ Departments.DepartmentID) | |
| 1 | 1 | 3 |
| 2 | 2 | 4 |
| 3 | 3 | 3 |
| 4 | 4 | 4 |
| 5 | 5 | 3 |
| 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 |