Civil_Engineers

idnameyears_of_experiencedesign_software_expertisesalary
1John Doe7AutoCAD80000.0
2Jane Smith3Revit65000.0
3Michael Johnson5AutoCAD75000.0
4Emily Brown9SketchUp90000.0
5David Wilson2Rhino60000.0

Design_Softwares

software_namepopularity
AutoCAD90
Revit80
SketchUp70
Rhino50
ArchiCAD60

Architects

idnameyears_in_practicedesign_software_expertisesalary
1Lisa Miller8AutoCAD85000.0
2William Taylor5Revit70000.0
3Olivia Davis7AutoCAD80000.0
4Samuel Moore9SketchUp95000.0
5Ethan Scott3Rhino65000.0

Projects

project_idtitledescriptionstart_dateend_date
1Bridge ConstructionBuilding a new bridge across the city river.2021-05-012022-07-31
2Office BuildingConstructing a new office building downtown.2021-06-012022-10-31
3Residential ComplexDeveloping a residential complex on the outskirts of town.2021-07-012023-07-31
4Highway ExpansionExpanding a busy highway to reduce traffic congestion.2021-08-012023-12-31
5Shopping MallBuilding a shopping mall with multiple stores and entertainment options.2021-09-012024-01-31

Engineer_Projects

engineer_idproject_id
(→ Civil_Engineers.id)(→ Projects.project_id)
11
12
23
34
45

Architect_Projects

architect_idproject_id
(→ Architects.id)(→ Projects.project_id)
11
23
35
42
54