The second print screen is a sales order, please put details in answer.

Problem 2 The Multi-Division Corp. keeps track of information about the budgeted and actual costs on various accounts for its many divisions. The data is currently stored in the following table. COSTS (DIV-NO, DIV-NAME, REGION, EMP-ID, E-NAME, RANK, ACCT-NO, ACCT- NAME, ACT-COST, BUD-COST). The DIV-NO field is the unique identifier of every division and DIV-NAME is the name of each division. The REGION field indicates the field in which each division is located. The EMP-ID field identifies the employee in charge of each division. The E-NAME contains the name of the employee and the RANK field indicates the rank of the employee. The ACCOUNT-NO field is the unique identifier of accounts for costs incurred. A division can have many accounts in which costs are incurred and a cost account can accumulate costs for many divisions. The ACC-NAME field contains the name of each account. Finally, the BUD-COST and ACT-COST fields indicate the budgeted and actual costs for each division on each account. Required: (1) Is the COSTS table in 3NF? Explain your answer, (2) If the table is not in 3NF, decompose the table to 3NF tables. Fiction Company 202 N. Main Mahattan, KS 66502 405 CustomerNumber: 1001 Customer Name: ABC Company Customer Address: 100 Points Manhattan, KS 66502 Sales Order Number: Sales Order Date: 2/1/2000 Clerk Number: 210 Clerk Name: Martin Lawrence Item Ordered Description 800 widgit small 801 tingimajigger thingibob Quantity Unit Price 40 60.00 20 20.00 10 100.00 Total 2,400.00 400.00 1,000.00 805 Order Total 3,800.00 Requirement: Prepare a set of 3NF tables to model the business process the document pertains to. Problem 2 The Multi-Division Corp. keeps track of information about the budgeted and actual costs on various accounts for its many divisions. The data is currently stored in the following table. COSTS (DIV-NO, DIV-NAME, REGION, EMP-ID, E-NAME, RANK, ACCT-NO, ACCT- NAME, ACT-COST, BUD-COST). The DIV-NO field is the unique identifier of every division and DIV-NAME is the name of each division. The REGION field indicates the field in which each division is located. The EMP-ID field identifies the employee in charge of each division. The E-NAME contains the name of the employee and the RANK field indicates the rank of the employee. The ACCOUNT-NO field is the unique identifier of accounts for costs incurred. A division can have many accounts in which costs are incurred and a cost account can accumulate costs for many divisions. The ACC-NAME field contains the name of each account. Finally, the BUD-COST and ACT-COST fields indicate the budgeted and actual costs for each division on each account. Required: (1) Is the COSTS table in 3NF? Explain your answer, (2) If the table is not in 3NF, decompose the table to 3NF tables. Fiction Company 202 N. Main Mahattan, KS 66502 405 CustomerNumber: 1001 Customer Name: ABC Company Customer Address: 100 Points Manhattan, KS 66502 Sales Order Number: Sales Order Date: 2/1/2000 Clerk Number: 210 Clerk Name: Martin Lawrence Item Ordered Description 800 widgit small 801 tingimajigger thingibob Quantity Unit Price 40 60.00 20 20.00 10 100.00 Total 2,400.00 400.00 1,000.00 805 Order Total 3,800.00 Requirement: Prepare a set of 3NF tables to model the business process the document pertains to