Reference no: EM133041248
-Dean wishes to use Access instead of Excel to store his Piano data, but couldn't the data be stored in an Excel spreadsheet? Why or why not?
-Is there any justification for Dean's decision to use Access to store the piano database?
-Examine the columns in Figure 1.
-Name three characteristics -- or 3 data items -- of the pianos that are not represented in this table.
-If you were a consultant advising Dean, what criteria should you and he use in deciding whether to include the additional data that you identified?
-Is this database a model of an inventory of pianos, or a model of Dean's model of an inventory of pianos? Explain the difference.
-Suppose, in addition to the data about pianos, Dean wants to store data about the manufacturer such as its address, years of operation, general comment about the manufacturer, etc.
-Design a Manufacturer table.
-Alter the design of the Piano Table (Figure 2) to represent the relationship between Piano and Manufacturer.
-Using the data in Figure 4, what conclusions can you make about the effect of location on piano sound quality. Justify and caveat your statements accordingly.