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 |