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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!