Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

answer all requirement in full detail!!! 5. Aggie Manufacturing Co. maintains information about its work orders, employees in charge of work orders, parts required for

answer all requirement in full detail!!! image text in transcribed
5. Aggie Manufacturing Co. maintains information about its work orders, employees in charge of work orders, parts required for work orders, and operations to be performed on work orders in the following table: WORK-ORDERS (WO-NO, WO-DATE, EMP-NO, EST-COST, ACT-COST, CUST-NO, CUST-NAME, CUST-ADDRESS, PART-NO, PART-DESC, QTY, OPERATION-NO, OP- DESC, DURATION). Work orders are performed for customers and require one or more parts and one or more operations. Each customer can have one or more work orders, but each work order can relate to only one customer. The WO-NO field is the unique identifier of work orders. The WO-DATE field contains the date the work order was created. The EMP-NO field indicates the employee in charge of the work order. The EST-COST and ACT-COST fields indicate the estimated and actual total costs on the work order. The PART-NO field contains the unique identifier of parts, while the PART-DESC field contains the description of each part. The 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 part could be used on many work orders). The OPERATION-NO field is the unique identifier of operations to be performed on each work order. The OP-DESC field contains the description of the operation. Finally, the DURATION field contains the duration of each operation required on each work order (a work order could require many operations, and an operation could be used on many work orders). Required: a. Is the WORK-ORDERS table in 3NF? Explain your answer. b. If the table is not in 3NF. decompose the table to 3NF tables. (Hint: you may find it useful to first construct an EER diagram, considering "work-order" as the event)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting In Emerging Economies

Authors: Mathew Tsamenyi

1st Edition

1849506256, 9781849506250

More Books

Students also viewed these Accounting questions

Question

What are your goals for this interview today?

Answered: 1 week ago