| 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 |
| 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 |
| id | firstName | lastName | 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 |
| 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 |
| 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 |