| id | name | years_of_experience | design_software_expertise | salary |
|---|---|---|---|---|
| 1 | John Doe | 7 | AutoCAD | 80000.0 |
| 2 | Jane Smith | 3 | Revit | 65000.0 |
| 3 | Michael Johnson | 5 | AutoCAD | 75000.0 |
| 4 | Emily Brown | 9 | SketchUp | 90000.0 |
| 5 | David Wilson | 2 | Rhino | 60000.0 |
| software_name | popularity |
|---|---|
| AutoCAD | 90 |
| Revit | 80 |
| SketchUp | 70 |
| Rhino | 50 |
| ArchiCAD | 60 |
| id | name | years_in_practice | design_software_expertise | salary |
|---|---|---|---|---|
| 1 | Lisa Miller | 8 | AutoCAD | 85000.0 |
| 2 | William Taylor | 5 | Revit | 70000.0 |
| 3 | Olivia Davis | 7 | AutoCAD | 80000.0 |
| 4 | Samuel Moore | 9 | SketchUp | 95000.0 |
| 5 | Ethan Scott | 3 | Rhino | 65000.0 |
| project_id | title | description | start_date | end_date |
|---|---|---|---|---|
| 1 | Bridge Construction | Building a new bridge across the city river. | 2021-05-01 | 2022-07-31 |
| 2 | Office Building | Constructing a new office building downtown. | 2021-06-01 | 2022-10-31 |
| 3 | Residential Complex | Developing a residential complex on the outskirts of town. | 2021-07-01 | 2023-07-31 |
| 4 | Highway Expansion | Expanding a busy highway to reduce traffic congestion. | 2021-08-01 | 2023-12-31 |
| 5 | Shopping Mall | Building a shopping mall with multiple stores and entertainment options. | 2021-09-01 | 2024-01-31 |
| engineer_id | project_id |
|---|---|
| (→ Civil_Engineers.id) | (→ Projects.project_id) |
| 1 | 1 |
| 1 | 2 |
| 2 | 3 |
| 3 | 4 |
| 4 | 5 |
| architect_id | project_id |
|---|---|
| (→ Architects.id) | (→ Projects.project_id) |
| 1 | 1 |
| 2 | 3 |
| 3 | 5 |
| 4 | 2 |
| 5 | 4 |