Construction_Projects
| ProjectID | Budget | Staff | Location | StartDate | EndDate |
| 1 | 1000000.0 | 20 | New York | 2023-01-01 | 2023-12-31 |
| 2 | 800000.0 | 15 | Los Angeles | 2023-02-01 | 2023-11-30 |
Employees
| EmployeeID | Name | Position | HireDate |
| 1 | John Doe | Project Manager | 2022-06-01 |
| 2 | Jane Smith | Architect | 2021-09-01 |
Materials
| MaterialID | Type | Quantity | UnitCost |
| 1 | Concrete | 500.0 | 75.0 |
| 2 | Steel Rebars | 300.0 | 100.0 |
Equipment
| EquipmentID | ModelName | RentalRate | PurchasePrice |
| 1 | Excavator X500 | 250.0 | 500000.0 |
| 2 | Cranes MX700 | 300.0 | 600000.0 |
Suppliers
| SupplierID | CompanyName | ContactInfo |
| 1 | ABC Concrete Supply | (555) 123-4567 |
| 2 | XYZ Steel Distribution | (555) 765-4321 |
Contractors
| ContractorID | CompanyName | ServicesOffered | LicenseNumber |
| 1 | PQR Construction Co. | General Contracting | Lic#123456 |
| 2 | STU Building Solutions | Subcontracting | Lic#654321 |