Design_Build_Firms

FirmIDNameAddress
1ABC Construction123 Main St
2XYZ Development456 Elm St
3PQR Builders789 Oak St
4MNO Homes000 Maple Ave
5LMN Contractors321 Pine St

Project_Types

TypeIDDescription
1Single Family Residential
2Multi-Family Residential
3Commercial
4Industrial
5Retail
6Custom Home

Design_Build_Firms_Project_Types

FirmIDTypeID
(→ Design_Build_Firms.FirmID)(→ Project_Types.TypeID)
16
26
36
46
56
51