| FirmID | Name | Address |
|---|---|---|
| 1 | ABC Construction | 123 Main St |
| 2 | XYZ Development | 456 Elm St |
| 3 | PQR Builders | 789 Oak St |
| 4 | MNO Homes | 000 Maple Ave |
| 5 | LMN Contractors | 321 Pine St |
| TypeID | Description |
|---|---|
| 1 | Single Family Residential |
| 2 | Multi-Family Residential |
| 3 | Commercial |
| 4 | Industrial |
| 5 | Retail |
| 6 | Custom Home |
| FirmID | TypeID |
|---|---|
| (→ Design_Build_Firms.FirmID) | (→ Project_Types.TypeID) |
| 1 | 6 |
| 2 | 6 |
| 3 | 6 |
| 4 | 6 |
| 5 | 6 |
| 5 | 1 |