Employers

employerIDcompanyNamelocation
1CompanyANew York
2CompanyBLos Angeles
3CompanyCChicago
4CompanyDMiami
5CompanyEHouston

Applicants

applicantIDfirstNamelastNameemailphoneNumberresumePath
1JohnDoejohn.doe@example.com+1 (123) 456-7890https://www.example.com/resume/johndoe.pdf
2JaneSmithjane.smith@example.com+1 (123) 456-7891https://www.example.com/resume/janesmith.pdf
3AliceJohnsonalice.johnson@example.com+1 (123) 456-7892https://www.example.com/resume/alicejohnson.pdf
4TomWilliamstom.williams@example.com+1 (123) 456-7893https://www.example.com/resume/tomwilliams.pdf
5LucyBrownlucy.brown@example.com+1 (123) 456-7894https://www.example.com/resume/lucybrown.pdf

Construction_Jobs

constructionJobIDjobTitlejobDescriptionrequiredSkillsconstructionJobTypedesignSoftware
(→ Design_Software_Expertise.softwareName)
1Senior Civil EngineerPlan, design, and supervise construction projects.Strong math and communication skills; Knowledge of building codes and regulations.Civil EngineeringAutoCAD
2Civil EngineerPlan, design, and supervise construction projects.Strong math and communication skills; Knowledge of building codes and regulations.Civil EngineeringRevit
3Senior ArchitectDesign buildings and spaces, ensuring functionality and aesthetics.Creative thinking, attention to detail, and knowledge of architectural principles.ArchitectureAutoCAD
4ArchitectDesign buildings and spaces, ensuring functionality and aesthetics.Creative thinking, attention to detail, and knowledge of architectural principles.ArchitectureRhino

Design_Software_Expertise

softwareIDsoftwareName
1AutoCAD
2Revit
3Rhino
4SketchUp
5Adobe Illustrator

Employed_in_Construction_Jobs

employedIDapplicantIDconstructionJobIDstartDateendDate
(→ Applicants.applicantID)(→ Construction_Jobs.constructionJobID)
1112023-01-152023-12-31
2222023-02-152023-12-31
3332023-03-152023-12-31
4442023-04-152023-12-31
5552023-05-152023-12-31