## Company

id | name | address | phoneNumber
--- | --- | --- | ---
1 | Company A | 123 Main St. | 555-0100
2 | Company B | 456 Elm St. | 555-0101
3 | Company C | 789 Oak St. | 555-0102
4 | Company D | 101 Pine St. | 555-0103
5 | Company E | 321 Fir St. | 555-0104

## JobPosting

id | title | description | postedDate | closingDate | companyId
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Company.id)
1 | Software Engineer | Experienced software engineer needed... | 2021-01-01 | 2021-01-31 | 1
2 | Data Analyst | Strong analytical skills required... | 2021-02-01 | 2021-02-28 | 2
3 | Project Manager | Proven track record managing projects... | 2021-03-01 | 2021-03-31 | 3
4 | QA Tester | Eye for detail needed for QA testing... | 2021-04-01 | 2021-04-30 | 4
5 | HR Specialist | Human resources experience a plus... | 2021-05-01 | 2021-05-31 | 5

## Employee

id | firstName | lastName | email | hireDate
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | 2020-06-01
2 | Jane | Smith | jane.smith@example.com | 2019-07-01
3 | Michael | Brown | michael.brown@example.com | 2018-08-01
4 | Emily | White | emily.white@example.com | 2020-09-01
5 | David | Black | david.black@example.com | 2017-10-01

## IT_Support_Technician

id | employeeId | itSupportSkills | operatingSystemKnowledge | startDate | endDate
--- | --- | --- | --- | --- | ---
| (→ Employee.id) |  |  |  |
1 | 1 | Basic IT Support Skills | Windows | 2021-01-01 | 2021-12-31
2 | 2 | Advanced IT Support Skills | Linux | 2020-01-01 | 2021-12-31
3 | 3 | IT Support Technician I | MacOS | 2019-01-01 | 2020-12-31
4 | 4 | IT Support Technician II | Unix | 2018-01-01 | 2019-12-31
5 | 5 | IT Support Technician III | All OS | 2017-01-01 | 2018-12-31

## Network_Administrator

id | employeeId | networkAdminSkills | operatingSystemKnowledge | startDate | endDate
--- | --- | --- | --- | --- | ---
| (→ Employee.id) |  |  |  |
1 | 1 | Cisco Router Configuration | Windows | 2021-01-01 | 2021-12-31
2 | 2 | Firewall Setup & Management | Linux | 2020-01-01 | 2021-12-31
3 | 3 | VPN Implementation | MacOS | 2019-01-01 | 2020-12-31
4 | 4 | Switch Configuration | Unix | 2018-01-01 | 2019-12-31
5 | 5 | Server Virtualization | All OS | 2017-01-01 | 2018-12-31