Lab 2 Normalization Submission Requirements remains the same as Lab 1. One of your colleagues at the HUMBER SYSTEMS INC. has just left the firm for another position, leaving the incomplete database design for a small new invoicing system on which they had been working. In this system, every product will be available from only one specific vendor. You have been asked to fully normalize the draft database (shown below) found in your colleague's working files. Complete the normalization process to third normal form, adding any tables or deleting any fields or tables, as required. Do not add any new field! Primary keys are identified by the "PK" abbreviation. Though you may find it useful to work through the normalization steps one at a time, you are only required to show your results at the end of 3NF, so only your 3NF design will be marked. Include foreign keys, and identify them by the FK abbreviation as well as the Entity Relationship Diagram of the tables in your 3NF. Use the rest of this page and the following page for any intermediate work and for your final answer. CLEARLY STATE ANY ASSUMPTIONS THAT YOU MAKE WHICH AFFECT YOUR FINAL 3NF DESIGN. INVOICE INVOICED PRODUCT CUSTOMER Customer_Number (PK) Customer_Name Customer_Address Customer_City Customer_Postal_Code Customer_Telephone Customer_Contact_Name Vendor_Contact_Name Invoice_Number (PK) Invoice_Date Payment_Terms Shipping Instructions Invoice_Subtotal GST_Payable PST_Payable Invoice_Grand_Total Invoice_Number(PK) Product_Number(PK) Product_Description Quantity Prouduct_Unit-Price Product_Total_Price PRODUCT Product_Number (PK) Product_Description Vendor_Number Vendor_Name Vendor_Address Vendor_City Vendor_Postal_Code Lab 2 Normalization Submission Requirements remains the same as Lab 1. One of your colleagues at the HUMBER SYSTEMS INC. has just left the firm for another position, leaving the incomplete database design for a small new invoicing system on which they had been working. In this system, every product will be available from only one specific vendor. You have been asked to fully normalize the draft database (shown below) found in your colleague's working files. Complete the normalization process to third normal form, adding any tables or deleting any fields or tables, as required. Do not add any new field! Primary keys are identified by the "PK" abbreviation. Though you may find it useful to work through the normalization steps one at a time, you are only required to show your results at the end of 3NF, so only your 3NF design will be marked. Include foreign keys, and identify them by the FK abbreviation as well as the Entity Relationship Diagram of the tables in your 3NF. Use the rest of this page and the following page for any intermediate work and for your final answer. CLEARLY STATE ANY ASSUMPTIONS THAT YOU MAKE WHICH AFFECT YOUR FINAL 3NF DESIGN. INVOICE INVOICED PRODUCT CUSTOMER Customer_Number (PK) Customer_Name Customer_Address Customer_City Customer_Postal_Code Customer_Telephone Customer_Contact_Name Vendor_Contact_Name Invoice_Number (PK) Invoice_Date Payment_Terms Shipping Instructions Invoice_Subtotal GST_Payable PST_Payable Invoice_Grand_Total Invoice_Number(PK) Product_Number(PK) Product_Description Quantity Prouduct_Unit-Price Product_Total_Price PRODUCT Product_Number (PK) Product_Description Vendor_Number Vendor_Name Vendor_Address Vendor_City Vendor_Postal_Code