Chat with AI
Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer
Edition 13ISBN: 978-0133058352Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer
Edition 13ISBN: 978-0133058352 Exercise 15
Answer Project Question 5.59, but use UML instead of the crow's foot model. Redraw Figure 5-57 using UML notation.
NOTE: Microsoft Visio 2010 and Microsoft Visio 2013 both have a UML template, and the drawings below were done using the Microsoft Visio 2010 template.
PQ 5.59 - Figure 5-56 shows the specifications for single-stage air compressor products. Note that there are two product categories that are based on Air Performance: The A models are at 125 pounds per square inch of pressure, and the E models are at 150 pounds per square inch of pressure. Using the structure and example data items in this list, do the following:
a. Create a set of exclusive subtypes to represent these compressors. The supertype will have attributes for all single-stage compressors, and the subtypes will have attributes for products having the two different types of Air Performance. Assume that there might be additional products with different types of Air Performance. Specify the entities, identifiers, attributes, relationships, type of category cluster, and possible determinant.
b. Figure 5-57 shows a different model for the compressor data. Explain the entities, their type, the relationship, its type, and its cardinality. How well do you think this model fits the data shown in Figure 5-56?
c. Compare your answer in question A with the model in Figure 5-57. What are the essential differences between the two models? Which do you think is better?
d. Suppose you had the job of explaining the differences in these two models to a highly motivated, intelligent end user. How would you accomplish this?
NOTE: Microsoft Visio 2010 and Microsoft Visio 2013 both have a UML template, and the drawings below were done using the Microsoft Visio 2010 template.
PQ 5.59 - Figure 5-56 shows the specifications for single-stage air compressor products. Note that there are two product categories that are based on Air Performance: The A models are at 125 pounds per square inch of pressure, and the E models are at 150 pounds per square inch of pressure. Using the structure and example data items in this list, do the following:
a. Create a set of exclusive subtypes to represent these compressors. The supertype will have attributes for all single-stage compressors, and the subtypes will have attributes for products having the two different types of Air Performance. Assume that there might be additional products with different types of Air Performance. Specify the entities, identifiers, attributes, relationships, type of category cluster, and possible determinant.
b. Figure 5-57 shows a different model for the compressor data. Explain the entities, their type, the relationship, its type, and its cardinality. How well do you think this model fits the data shown in Figure 5-56?
c. Compare your answer in question A with the model in Figure 5-57. What are the essential differences between the two models? Which do you think is better?
d. Suppose you had the job of explaining the differences in these two models to a highly motivated, intelligent end user. How would you accomplish this?
Explanation
Verified
Verified
a.
MS Visio has a Type object that we wi...
Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
