Trade_Jobs

idtrade_jobcompany_ownerposted_datesalary
1Construction WorkerDerek Brown2023-01-0140000.0
2Construction WorkerJohn Smith2023-01-0245000.0
3ElectricianDerek Brown2023-02-0160000.0
4ElectricianMary Johnson2023-02-0265000.0

Company

idnamecontact_numberaddress
(→ Trade_Jobs.company_owner)
1ABC Construction+123456789123 Main St
2XYZ Electricians+987654321456 Elm St

Employee

idemployee_namepositionhire_date
(→ Trade_Jobs.trade_job)
1Alice JonesManager2018-01-01
2Bob SmithSupervisor2019-02-01

Education

iddegreemajorinstitutioncompletion_year
(→ Employee.position)
1Project ManagerBusiness AdministrationState University2017
2Marketing SpecialistMarketingCity College2018