Product Manufacturer 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 below: Vendor Component 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 track 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. Source: Rob, P. & Coronel, C. 2002. Database systems: Design, Implementation and Management. 5th ed. USA: Thomson. p 392. 1.1 Identify four classes from the scenario above. Also indicate possible attributes for each class. (8 Marks) 1.2 Draw a class diagram and document the relationships with the appropriate multiplicities. (11 Marks) 1.3 Draw a sample object diagram from your class diagram. (5 Marks) 1.4 There are full time, part time and contract staff working for the manufacturer. Illustrate with a diagram how this can be implemented with generalisation and specialisation. (6 Marks)
