Page 234 -

Figure 5-32 Case Study 5 233
Car Parts
Source: © sima/Shuttetstock

QUeStionS b. Alter the design of the Part table (Figure 5-33) to
represent the relationship between Part and Manu-
5-13. Explain why a simple, one-table only, Access database
can be defined as a database with all of its benefits even facturer. State and justify any assumptions.
though the data could be straightforwardly stored as an 5-17. Using the data in Figure 5-34, draw conclusions about
Excel spreadsheet. the location and characteristics of the temperature
5-14. Justify the decision to use Access to store the classic and sensor parts, their brand, and their location in the rack-
vintage car parts data. ing system.
5-15. Examine the columns in Figure 5-33. 5-18. Explain the statement “A database is an abstraction of
a. Name three features of classic and vintage car parts some aspects of a business.” Using this example, ex-
that are not represented in this table. plain the ways that processing an abstraction is more
b. If you were a business analyst advising Shane, effective than examining car parts. Generalize your ob-
what criteria should you use in deciding whether to servation to databases for business in general.
include the additional data?
5-19. This database will soon become useless if it is not kept
5-16 Suppose that, in addition to the data about car parts, up-to-date. List procedures that Shane needs to create
Shane wants to store data about the manufacturer and follow to keep his database current.
such as its address, its years of manufacture, and gen-
eral comments about the manufacturer.
a. Design a Manufacturer table.