Employers

idnameaddress
1Employer A123 Main St
2Employer B456 Elm St
3Employer C789 Oak St

Locations

idcitystate
1City XState AA
2City YState BB
3City ZState CC

Skills

idskillName
1Skill A
2Skill B
3Skill C
4Skill D
5Skill E

Requirements

idrequirement
1Requirement 1
2Requirement 2
3Requirement 3
4Requirement 4
5Requirement 5

JobPostings

idtitledescriptionhealthcareshiftemployerIdlocationIdskillsIdsrequirementsIds
(→ Employers.id)(→ Locations.id)
1Job 1Description of Job 1NurseDay Shift11A,B1,2
2Job 2Description of Job 2NurseNight Shift12C,D3,4
3Job 3Description of Job 3Physical TherapistDay Shift21E5
4Job 4Description of Job 4Physical TherapistNight Shift226
5Job 5Description of Job 5Software EngineerFlexible33A,C,E7,8