Suppose we wish to develop a database consisting of contractor names, addresses and particular specialties as in Table 14-3 1. Suggest two hierarchical organizations of this data. 2. Suggest an alternative relational organization for this data. 3. Which organization would you recommend for implementation of a database?

TABLE 14-3 Subcontractor Relation Example Attribute Example NAME XYZ Electrical Co. CONTACT Betty XYZ PHONE (412) XXX-XXXX STREET XXX Mulberry St. CITY Pittsburgh STATE PA ZIPCODE 152xx SIZE large CONCRETE no ELECTRICAL yes MASONRY no etc