Figure:5.56 Figure 5-56 shows the specifications for single-stage air compressor products. Note that two product categories are
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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% 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%
Expert Answer:
Answer rating: 100% (QA)
Youve provided screenshots related to a singlestage air compressor product specifications and some conceptual database model diagrams Since this seems to be a multipart question from a student I will ... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Research serves as a guide by which to study, describe, and quantify an array of social and physical phenomenon. Theory, which is best described as a set of propositions or hypotheses that specify...
-
The net weight in pounds of a packaged chemical herbicide is uniform for pounds. (a) Determine the mean and variance of the weight of packages. (b) Determine the cumulative distribution function of...
-
Which compound in each of the following pairs will react faster in an SN2 reaction with OH? (a) CH3Br or CH3I (b) CH3CH2I in ethanol or in dimethyl sulfoxide (c) (CH3) 3CC1 or CH3C1 (d) H2C = CHBr or...
-
What mechanisms are available to help provide stakeholders with an assurance that a company complies with environmental regulations?
-
In early January 2013, Strawberry Corporation applied for a trade name, incurring legal costs of $50,000. In January 2014, Strawberry incurred $20,000 of legal fees in a successful defense of its...
-
What are two ways that may help a Bank avoid it's collapse in terms of risk management practices?
-
In 2016 the Harris poll estimated that 3.3% of American adults are vegetarian. A nutritionist thinks this rate has increased. The nutritionist samples 150 American adults and finds that 11 are...
-
Kroger Co. is one of the largest retail food companies in the United States as measured by total annual sales. The Kroger Co. operates supermarkets, convenience stores, and manufactures and processes...
-
What implications do you believe exist with MACRA? Do you believe that moving to a paymentfor-quality model over quantity/volume is going to improve patient outcomes? Why?
-
Explain each of the following: a. reserve ratio b. required reserves
-
Which rate should be higher: the overnight repo rate, or the overnight federal funds rate? Why?
-
With all the changes that are occurring in healthcare today, what are some of the challenges your environment is facing and what is your organization doing to plan for the financial consequences?
-
Explain each of the following types of deposit accounts: a. demand deposit b. certificate of deposit c. money market demand account
-
A stock is expected to pay its first $ 640 dividend in 1 year from now. The dividend is expected to be paid annually forever and grow by -2 % pa (note the negative sign). The discount rate is 4 % pa....
-
Convert the numeral to a HinduArabic numeral. A94 12
-
Identify the three essential characteristics that define an asset, one of the key elements of financial statements.
-
On August 31, 2019, Angela Corp. (AC) classified a surplus machine as held for sale. The equipment is available for immediate sale and is expected to sell within one year. Pertinent information...
-
Refer to problem P10-31. Assume that Super Computers Inc. is a private company that elects to report its financial results in accordance with ASPE. Provide the required information above. Data from...
-
As the head of research for a biological research organization, you recently purchased a \($2,000\) commercial refrigerator for storing research samples. Recently, you suffered a loss of more than...
-
Because students use e-mail to communicate with other group members when they write collaboratively, your college or university would like to create a one-page handout on how to use e-mail...
-
As the recipient of the claim letter described in Exercise 1, write an adjustment letter granting the customers request. data from exercise 1 As the head of research for a biological research...
Study smarter with the SolutionInn App