Companies

idnamelocation_id
(→ Locations.id)
1Company A1
2Company B2
3Company C3
4Company D4
5Company E5

Locations

idcitystatecountry
1New YorkNYUSA
2Los AngelesCAUSA
3ChicagoILUSA
4HoustonTXUSA
5TorontoONCanada

Qualifications

idrequirement
1Bachelor's degree in Civil Engineering
2Experience with Revit software
3Proficiency in AutoCAD software
4Strong communication skills
5Ability to work under pressure

JobPostings

idtitlecompany_idconstruction_jobdesign_software_expertiseyears_of_experiencesalary_rangequalification_id
(→ Companies.id)(→ Qualifications.id)
1Civil Engineer11AutoCAD5$60k-$70k1
2Civil Engineer11SketchUp4$55k-$65k2
3Architect20AutoCAD8$75k-$85k3
4Architect20Rhino + Grasshopper6$70k-$80k4

Requirements

idjobposting_idqualification_id
(→ JobPostings.id)(→ Qualifications.id)
111
212
323
424