id | name | years_of_experience |
---|---|---|
1 | John | 20 |
2 | Anna | 30 |
3 | James | 25 |
4 | Emma | 28 |
5 | Michael | 27 |
tool_id | tool_name | type |
---|---|---|
1 | Software_Modeling | software |
2 | Road_Simulation | hardware |
3 | Vehicle_Tracking | hardware |
4 | Accident_Analysis | software |
5 | Signal_Optimization | software |
engineer_id | tool_id |
---|---|
(→ Traffic_Engineers.id) | (→ Tools.tool_id) |
1 | 1 |
1 | 2 |
2 | 1 |
2 | 3 |
3 | 1 |
3 | 2 |
4 | 2 |
4 | 5 |
5 | 3 |
5 | 4 |
4 | 1 |
5 | 1 |