## Trade_Jobs

id | trade_job | company_owner | posted_date | salary
--- | --- | --- | --- | ---
1 | Construction Worker | Derek Brown | 2023-01-01 | 40000.0
2 | Construction Worker | John Smith | 2023-01-02 | 45000.0
3 | Electrician | Derek Brown | 2023-02-01 | 60000.0
4 | Electrician | Mary Johnson | 2023-02-02 | 65000.0

## Company

id | name | contact_number | address
--- | --- | --- | ---
(→ Trade_Jobs.company_owner) |  |  |
1 | ABC Construction | +123456789 | 123 Main St
2 | XYZ Electricians | +987654321 | 456 Elm St

## Employee

id | employee_name | position | hire_date
--- | --- | --- | ---
| (→ Trade_Jobs.trade_job) |  |
1 | Alice Jones | Manager | 2018-01-01
2 | Bob Smith | Supervisor | 2019-02-01

## Education

id | degree | major | institution | completion_year
--- | --- | --- | --- | ---
| (→ Employee.position) |  |  |
1 | Project Manager | Business Administration | State University | 2017
2 | Marketing Specialist | Marketing | City College | 2018