Normalize the following table structure. Show the dependency diagram for each of the normal forms. Do not go beyond the 3rd normal form. NOTE
a) You can assume that the table does not contain repeating groups and that any invoice number may reference more than one product. Attributes are listed in the first column instead of the first row (Hint: This table uses a composite primary key.)
b) You can assume that any given product is supplied by a single vendor but a vendor can supply many products. Therefore, it is proper to conclude that the following dependency exists:
PROD_NUM → PROD_DESCRIPTION, PROD_PRICE, VEND_CODE, VEND_NAME