Create/Make a EERD Diagram based off the information given in the screenshot and make it according to
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. Create an EERD to show how you would track this information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality. Submit a screenshot in docx, pdf, doc file format of your EERD showing the entities, primary keys, attributes for each entity, and crows feet/relationships. Assumptions A supplier can exist without providing components. A component does not have to be associated with a supplier. A component does not have to be associated with a product. Not all components are used in products. A product cannot exist without components. A manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. Create an EERD to show how you would track this information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality. Submit a screenshot in docx, pdf, doc file format of your EERD showing the entities, primary keys, attributes for each entity, and crows feet/relationships. Assumptions A supplier can exist without providing components. A component does not have to be associated with a supplier. A component does not have to be associated with a product. Not all components are used in products. A product cannot exist without components.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
An investment project has annual cash inflows of $3,200, $4,100, $5,300, and $4,500, and a discount rate of 14 percent. What is the discounted payback period for these cash flows if the initial cost...
-
Complete the following table: Account ________________ Category ______ ____ Temporary or Permanent Purchases Purchases Returns and Allowances Purchases Discount
-
Find a bound for the error in Exercise 2 using the error formula, and compare this to the actual error. In Exercise 2 0,25 (cos x)2 dx -0.25 .0 x In(x 1) dx -0.5 ((sin x) 2xsn) dx 0.7S dx xInx
-
A rotor, having a mass moment of inertia \(J_{1}=15 \mathrm{~kg}-\mathrm{m}^{2}\), is mounted at the end of a steel shaft having a torsional stiffness of \(0.6 \mathrm{MN}-\mathrm{m} /...
-
Della Bee Company purchased a manufacturing plant building 10 years ago for $1,300,000. The building has been depreciated using the straight-line method with a 30-year useful life and 10% residual...
-
A spherical shell contains three charged objects. The first and second objects have a charge of -15.0 nC and 34.0 nC, respectively. The total electric flux through the shell is -638 N-m/C. What is...
-
Do you think some businesses spend too much time researching information on the internet and not actually becoming involved with community events? (Comment)
-
An ocean wave is cyan. What color(s) of light does it absorb? What colors does it reflect?
-
State whether each of the following is an example of a physical or chemical property of matter: (a) Graphite conducts electricity. (b) Bismuth, Bi, loses its iridescence upon melting. (c) A copper...
-
If \(n_{1}=31, s_{1}=12, n_{2}=51\), and \(s_{2}=10\), test whether \(\sigma_{1}>\sigma_{2}\) at the \(\alpha=0.05\) level of significance. Perform the appropriate hypothesis test.
-
Define the wavelength of sound in terms of successive compressions of air.
-
Distinguish between the white of this page and the black of this ink, in terms of what happens to the white light that falls on both.
-
A piezometer and a Pitot tube are tapped into a 3-cm diameter horizontal water pipe, and the height of the water columns are measured to be 20 cm in the piezometer and 35 cm in the Pitot tube (both...
-
Draw the appropriate control flow graph of the given pseudocode.Make sure to only use one number for blocks of code which are all sequential and when the first line is executed, all of those lines...
-
The Coca-Cola Company reported "Net cash provided by operating activities" of $7,150 million in its 2007 cash flow statement. It also reported interest paid of $405 million and interest income of...
-
Why might the shares of the acquiring from in an acquisition decline on announcement of the acquisition?
-
Here are some accounting numbers and market values (in millions) for Hewlett-Packard and Gateway for 2002. These two computer manufactures are considered to be comparables for Dell, Inc. a. Calculate...
-
Nitrogen is compressed to a density of \(4 \mathrm{~kg} / \mathrm{m}^{3}\) under an absolute pressure of \(400 \mathrm{kPa}\). Determine the temperature in degrees Celsius.
-
A regulation basketball is initially flat and is then inflated to a pressure of approximately \(24 \mathrm{lb} / \mathrm{in}^{2}\) absolute. Consider the air temperature to be constant at...
-
The presence of raindrops in the air during a heavy rainstorm increases the average density of the air-water mixture. Estimate by what percent the average air-water density is greater than that of...
Study smarter with the SolutionInn App