## Civil_Engineers

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

## Design_Softwares

software_name | popularity
--- | ---
AutoCAD | 90
Revit | 80
SketchUp | 70
Rhino | 50
ArchiCAD | 60

## Architects

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

## Projects

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_Projects

engineer_id | project_id
--- | ---
(→ Civil_Engineers.id) | (→ Projects.project_id)
1 | 1
1 | 2
2 | 3
3 | 4
4 | 5

## Architect_Projects

architect_id | project_id
--- | ---
(→ Architects.id) | (→ Projects.project_id)
1 | 1
2 | 3
3 | 5
4 | 2
5 | 4