FIGURE 7.6 Revised UML Class Diagram for Sunset's Conversion Process Material o Materials Issue 1.1 1.1 Bill of Material Production Authorization Sunset 1Partners 1..1 1..1 1..1 1..1 Labor Products Operations O. Product 1.1 Categories FIGURE 7.7 Linked Conversion Process Tables and with Referential Integrity Enforced tblMaterials tbiMaterial_Issue Material number Materialdescription Material,price Material quantity.on hand Material notes Issue date ssued by Prod Auth number tblMaterial Issue Material Matl issue number Material number Qty issued tblBill of Material BOM number Issue sequence Standard quantity Product number Material_number Special_handiing Prod auth,date Rroduct Number Sched,qty.to produce Actual qty.produced Scheduled, completion.c Actual completion, date Overhead rate tblPartners Partner,number Partner first, name Partner last name Partner hire,date Partner SocSecNo Partner Address Partner Address2 tblProducts tblLabor Operations Product,description Labor Ops Number Prod auth number Labor ops description Product,unit, of sale Product, category Product quantity Product notes tblLabor Partners Product,category.number Product, category,description Product, category manager Product,category.notes Labor ops number Partner number Actual direct labor hours Actual direct labor wage Compare Figure 76 with Figure 7.Z. Which of the following describes the differences between those two figures? Multiple Choice Figure 7.7 includes tblLabor_Operations_Partners to implement the many-to-many relationship between tblPartners and tblLabor_Operations. Figure 7.7 includes tblMaterial Issue_Material to implement the many-to-many relationship between tblMaterial_Issue and tblMaterials Figure 7.6 includes the minimum multiplicities to specify data integrity requirements. Figure 7.7 only shows maximum cardinalities between linked tables. All of the choices are differences between the two figures. Which of the following is a business rule implementing access control for the conversion process? Multiple Choice Employee authorizing production cannot modify inventory records. System must provide control numbers. Employees preparing quotes cannot modify established prices. System must create audit trail whenever records are changed. None of the choices are correct. Review Figure 77. Which of the following describes the purpose of the Bill of Material class? Multiple Choice Record the invoices from suppliers for materials purchased Record the planned raw material contents of each finished good Record the authorization of production Describe the labor required for each finished good None of the choices are correct
