Construction_Companies

idcompany_namelocation
1Company ANew York
2Company BLos Angeles
3Company CChicago
4Company DHouston
5Company EMiami

Projects

idproject_typestart_dateend_date
1Foundation2023-01-012023-06-01
2Residential2023-07-012023-12-01
3Commercial2024-01-012024-12-01
4Industrial2025-01-012025-12-01
5Infrastructure2026-01-012026-12-01

Construction_Companies_Projects

construction_company_idproject_id
(→ Construction_Companies.id)(→ Projects.id)
11
21
31
41
51
52

House_Sizes

house_size_idsize_in_sqftprice
11500200
22000250
32500300
43000350
53500400

Material_Types

material_type_idtype_of_materialcost_per_unit
1Concrete50.0
2Steel80.0
3Wood40.0
4Aluminum90.0
5Glass70.0