Suppose a manufacturer produces three highcost, lowvolume products: P1, P2, and P3. Product P1 is assembled with

Question:

Suppose a manufacturer produces three high‑cost, low‑volume products: P1, P2, and P3. Product P1 is assembled with components C1 and C2; product P2 is assembled with components C1, C3, and C4; and product P3 is assembled with components C2 and C3. Components may be purchased from several vendors, as shown in Table PB.5:


Table PB.5 The Component/Vendor Summary

VENDOR

COMPONENTS SUPPLIED

V1

C1, C2

V2

C1, C2, C3, C4

V3

C1, C2, C4


Each product has a unique serial number, as does each component. To keep track of product performance, careful records are kept to ensure that each product's 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 manufacturer's product/component tracking requirements.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: