Construction_Companies
| id | company_name | location |
| 1 | Company A | New York |
| 2 | Company B | Los Angeles |
| 3 | Company C | Chicago |
| 4 | Company D | Houston |
| 5 | Company E | Miami |
Projects
| id | project_type | start_date | end_date |
| 1 | Foundation | 2023-01-01 | 2023-06-01 |
| 2 | Residential | 2023-07-01 | 2023-12-01 |
| 3 | Commercial | 2024-01-01 | 2024-12-01 |
| 4 | Industrial | 2025-01-01 | 2025-12-01 |
| 5 | Infrastructure | 2026-01-01 | 2026-12-01 |
Construction_Companies_Projects
| construction_company_id | project_id |
| (→ Construction_Companies.id) | (→ Projects.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 2 |
House_Sizes
| house_size_id | size_in_sqft | price |
| 1 | 1500 | 200 |
| 2 | 2000 | 250 |
| 3 | 2500 | 300 |
| 4 | 3000 | 350 |
| 5 | 3500 | 400 |
Material_Types
| material_type_id | type_of_material | cost_per_unit |
| 1 | Concrete | 50.0 |
| 2 | Steel | 80.0 |
| 3 | Wood | 40.0 |
| 4 | Aluminum | 90.0 |
| 5 | Glass | 70.0 |