Company

idnameaddressphoneNumber
1Company A123 Main St.555-0100
2Company B456 Elm St.555-0101
3Company C789 Oak St.555-0102
4Company D101 Pine St.555-0103
5Company E321 Fir St.555-0104

JobPosting

idtitledescriptionpostedDateclosingDatecompanyId
(→ Company.id)
1Software EngineerExperienced software engineer needed...2021-01-012021-01-311
2Data AnalystStrong analytical skills required...2021-02-012021-02-282
3Project ManagerProven track record managing projects...2021-03-012021-03-313
4QA TesterEye for detail needed for QA testing...2021-04-012021-04-304
5HR SpecialistHuman resources experience a plus...2021-05-012021-05-315

Employee

idfirstNamelastNameemailhireDate
1JohnDoejohn.doe@example.com2020-06-01
2JaneSmithjane.smith@example.com2019-07-01
3MichaelBrownmichael.brown@example.com2018-08-01
4EmilyWhiteemily.white@example.com2020-09-01
5DavidBlackdavid.black@example.com2017-10-01

IT_Support_Technician

idemployeeIditSupportSkillsoperatingSystemKnowledgestartDateendDate
(→ Employee.id)
11Basic IT Support SkillsWindows2021-01-012021-12-31
22Advanced IT Support SkillsLinux2020-01-012021-12-31
33IT Support Technician IMacOS2019-01-012020-12-31
44IT Support Technician IIUnix2018-01-012019-12-31
55IT Support Technician IIIAll OS2017-01-012018-12-31

Network_Administrator

idemployeeIdnetworkAdminSkillsoperatingSystemKnowledgestartDateendDate
(→ Employee.id)
11Cisco Router ConfigurationWindows2021-01-012021-12-31
22Firewall Setup & ManagementLinux2020-01-012021-12-31
33VPN ImplementationMacOS2019-01-012020-12-31
44Switch ConfigurationUnix2018-01-012019-12-31
55Server VirtualizationAll OS2017-01-012018-12-31