Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 . Suppose a manufacturer produces three high - cost , low - volume products: P 1 , P 2 , and P 3 .
Suppose a manufacturer produces three highcost lowvolume products: P P and P Product P is assembled with components C and C; product P is assembled with components Cl C and C; and product P is assembled with components C and C Components may be purchased from several vendors, as shown in the following table.
Suppose a manufacturer produces three highcost lowvolume products: P P and P Product P is assembled with components C and C; product P is assembled with components Cl C and C; and product P is assembled with components C and C Components may be purchased from several vendors, as shown below.
Vendor Component Supplied
V C C
V CCCC
V CCC
Each product has a unique serial number, as does each component. To track product performance, careful records are kept to ensure that each products components can be traced to the component supplier.
Products are sold directly to final customers; that is no wholesale operations are permitted. The sales records include the customer identification and the product serial number. Using the preceding information, do the following:
a Write the business rules governing the production and sale of the products.
b Create an ER diagram capable of supporting the manufacturers productcomponent tracking requirements.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started