The Multi-Division Corp. keeps track of information about the budgeted and actual costs on various accounts for
Question:
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.
(1) Is the COSTS table in 3NF? Explain your answer, (2) If the table is not in 3NF, decompose the table to 3NF tables.