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 |