Copy of Aggie Manufacturing Co. custom builds products for customers. The description of the product is...

Transcribed Image Text:

Copy of Aggie Manufacturing Co. custom builds products for customers. The description of the product is called a "work order"; work orders are then assembled in the manufacturing plant. The production of the product for a customer is therefore called a "work order assembly". Aggie maintains information about its work order assemblies, employees who do the work order assembly, customers, parts required for work order assembly, and operations to be performed during the work order assembly. Each work order assembly is performed by one and only one employee. That employee performs all the operations that are necessary for that work order assembly. Work orders are assembled for customers and require one or more parts and one or more operations. Each customer could have many work orders, but each work order can relate to only one customer. All data is contained in the following 3-table database: • WORK_ORDER_ASSEMBLY (WO-NO, WO-DATE, EMP-NO, EMP-NAME, EST-COST, CUST-NO, CUST-NAME, CUST-ADDRESS, OPERATION-NO*) • WORK_ORDER_PARTS (WO-NO* PART-NO, PART-DESC, QTY) • OPERATIONS (OPERATION-NO, OP-DESC) Definitions of some fields: • WO-NO field is the unique identifier of work orders. • WO-DATE field contains the date the work order was created. • EMP-NO field indicates the employee in charge of the work order. • CUST-NO field indicates the customer that ordered the product manufactured by the work order. • CUST-NAME field indicates the name of the customer • EST-COST field indicates the estimated costs on the work order before assembly. • PART-NO field contains the unique identifier of parts. • PART-DESC field contains the description of each part. • QTY field is used to indicate the quantity of each part required on each work order (a work order could require many parts, and the same kind of part could be used on many work orders). • OPERATION-NO field is the unique identifier of operations to be performed on each work order. • OP-DESC field contains the description of the operation. Required: Does this database contain a transitive dependency? If yes, describe [ONE] transitive dependency by naming the fields and how they create the dependency. Copy of Aggie Manufacturing Co. custom builds products for customers. The description of the product is called a "work order"; work orders are then assembled in the manufacturing plant. The production of the product for a customer is therefore called a "work order assembly". Aggie maintains information about its work order assemblies, employees who do the work order assembly, customers, parts required for work order assembly, and operations to be performed during the work order assembly. Each work order assembly is performed by one and only one employee. That employee performs all the operations that are necessary for that work order assembly. Work orders are assembled for customers and require one or more parts and one or more operations. Each customer could have many work orders, but each work order can relate to only one customer. All data is contained in the following 3-table database: • WORK_ORDER_ASSEMBLY (WO-NO, WO-DATE, EMP-NO, EMP-NAME, EST-COST, CUST-NO, CUST-NAME, CUST-ADDRESS, OPERATION-NO*) • WORK_ORDER_PARTS (WO-NO* PART-NO, PART-DESC, QTY) • OPERATIONS (OPERATION-NO, OP-DESC) Definitions of some fields: • WO-NO field is the unique identifier of work orders. • WO-DATE field contains the date the work order was created. • EMP-NO field indicates the employee in charge of the work order. • CUST-NO field indicates the customer that ordered the product manufactured by the work order. • CUST-NAME field indicates the name of the customer • EST-COST field indicates the estimated costs on the work order before assembly. • PART-NO field contains the unique identifier of parts. • PART-DESC field contains the description of each part. • QTY field is used to indicate the quantity of each part required on each work order (a work order could require many parts, and the same kind of part could be used on many work orders). • OPERATION-NO field is the unique identifier of operations to be performed on each work order. • OP-DESC field contains the description of the operation. Required: Does this database contain a transitive dependency? If yes, describe [ONE] transitive dependency by naming the fields and how they create the dependency.

Answer rating: 100% (QA)

In the image you presented a scenario from the Aggie Manufacturing Company which uses a database to ... View the full answer