Question: PARTI: NORMALIZATION PROBLEM Given a table named Invoice with the following columns INV_NUM PK PROD_NUM PK SALE_DATE PROD_DESCRIPTION VEND_CODE VEND_NAME NUMBER_SOLD PROD_PRICE 1. Create a

PARTI: NORMALIZATION PROBLEM Given a table named "Invoice" with the following columns INV_NUM PK PROD_NUM PK SALE_DATE PROD_DESCRIPTION VEND_CODE VEND_NAME NUMBER_SOLD PROD_PRICE 1. Create a dependency diagram and identify all partial and transitive dependencies within the Invoice table. 2. Work through the normalization process until the resulting relation(s) are in 3rd Normal Form (3NF) 3. Submit the normalized design using a Word file named "Invoice.docx" on Blackboard. The file should show the progression from 1st to 2nd to 3rd Normal Form (i.e., an image showing 2nd and 3rd normal forms)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
