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.
Step by Step Answer:
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris