1. Examine the columns in Figure 5-33. Name three characteristics of pianos that are not represented in this table.

   1. If you were a consultant advising Dean, what criteria should you and he use in deciding whether to include that additional data?

   2. Is this database a model of an inventory of pianos, or is it a model of Deans model of an inventory of pianos? Explain the difference

2. 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.

   1. Design a Manufacturer table.

   2. Alter the design of the Piano table (Figure 5-33) to represent the relationship between Piano and Manufacturer. State and justify any assumptions.

C. UMIS_10e-CH05-Figure,5-33-Dean Pianos T Randall Boyle File Home Create External Data Database Tools DTell me what you want to do Builder View Property Indexes Create Data RenameRelationships Object Test Validation Rules Sheet Macros Delete Macro Dependencies Views Tools Show/Hide Field, Record&Table Events Relationships Piano Field Name Data Type Description (Optional) ID Brand Serial Number Color Type Building Location Sound Board Venier Strings Felts Key Type Percent Missing Pedals Sound Remarks AutoNumber Short Text Number Short Text Short Text Short Text Short Text Short Text Short Text Short Text Short Text Short Text Number Short Text Number Short Text Number Field Properties General Lookup Field Size New Values Format Caption Indexed Text Align Long Integer Increment Yes (No Duplicates) General A field name can be up to 64 characters long, including spaces. Press F1 for help on field names >> I Piano Field Name Data Type Description (Optional) ID Brand Serial Number Color Type Building Location Sound Board Venier Strings Felts Key Type Percent Missing Pedals Sound Remarks AutoNumber Short Text Number Short Text Short Text Short Text Short Text Short Text Short Text Short Text Short Text Short Text Number Short Text Number Short Text Number Field Properties General Lookup Field Size New Values Format Caption Indexed Long Integer Increment Yes (No Duplicates)