Suppose, in addition to the data about pianos, Dean wants to store data about the manufacturer such as its address (or last known address), its years of operation, and general comments about that manufacturer.

a. Design a Manufacturer table.

b. Alter the design of the Piano table (Figure 5-21)

to represent the relationship between Piano and Manufacturer. State and justify any assumptions.