Figure:5.56

 

Figure 5-56 shows the specifications for single-stage air compressor products. Note that two product categories are based on Air Performance: the A models are at 125 pounds per square inch of pressure, and the C models are at 150 pounds per square inch of pressure. Using the structure and example data items in this list, do the following: JNJ KO 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 with 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, exclusive/inclusive and total/partial properties, and possible discriminator. Symbol MSFT NKE TSLA B. Figure 5-57 shows a different model for the compressor data. Explain the entities, their types, the relationship, its type, and its cardinality. How well do you think this model fits the data shown in Figure 5-56? SCOMPX SINDU AMZN CISCO DVMT INTC Exchange NASDAQ NYSE NASDAQ NASDAQ NYSE NASDAQ NYSE NYSE NASDAQ NYSE NASDAQ NASDAQ Composite Index Dow Jones Industrial Average Amazon.com Inc. Cisco Systems Inc. Dell Technologies Inc. Intel Corporation Johnson & Johnson Coca-Cola Company Microsoft Corporation Name NIKE Inc. Tesla Motors Inc. Last Close Change Pet Change 6,387.75 -0.040% 21,580.07 1,025.67 31.84 63.63 34.75 135.31 45.03 T 73.79 59.95 328.40 -2.25 -31.71 -3.03 -0.02 -0.31 -0.02 -1.26 0.21 -0.43 0.85 -1.52 -0.150% -0.290% -0.060% -0.480% -0.060% -0.920% 0.470% -0.580% 1.440% -0.460%