Lab 2 Normalization Submission Requirements remains the same as Lab 1. One of your colleagues at the HEREDER 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 2NF, 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. CUSTOMER INVOICE INVOICED PRODUCT PRODUCT Customer_Number (PK) Invoice_Number (PK) Invoice_Number(PK) Product_Number (PK) Customer_Name Invoice_Date Product_Number(PK) Product_Description Customer_Address Payment_Terms Product_Description Vendor_Number Customer_City Shipping_Instructions Quantity Vendor_Name Customer_Postal_Code Invoice_Subtotal Prouduct_Unit-Price Vendor_Address Customer_Telephone GST_Payable Product_Total_Price Vendor_City Customer_Contact_Name PST_Payable Vendor_Postal_Code Vendor_Contact_Name Invoice_Grand_Total Lab Normalization of incomplete tables Name Description Rubric Detail Levels of Achievement Competent Criteria Proficient Identification of tables and columns in 3NF O to 0.35 points Student has identified some tables in 3NF There are se some tables that are not in SNF and some Pks and FKs are Identified 0.35 to 0.75 points Student has identified all tables in SNF and all Pks and FKs are Identified Entity Relationship Diagram 0 to 0.25 points Entity relationship diagram is missing some tables Columns or cardinality with somewhat clarity hence demonstrates limited knowledge of Normalization process 0.25 to 0.5 points Entity relationship diagram is presenting all tables, columns or cardinality with high degree of clarity hence demonstrates excellent inowledge of Normalization process 0 to 0 points Assumptions are clearly made 0 to 0.25 points Assumptions made are clear logical and realistic Lab 2 Normalization Submission Requirements remains the same as Lab 1. One of your colleagues at the HEREDER 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 2NF, 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. CUSTOMER INVOICE INVOICED PRODUCT PRODUCT Customer_Number (PK) Invoice_Number (PK) Invoice_Number(PK) Product_Number (PK) Customer_Name Invoice_Date Product_Number(PK) Product_Description Customer_Address Payment_Terms Product_Description Vendor_Number Customer_City Shipping_Instructions Quantity Vendor_Name Customer_Postal_Code Invoice_Subtotal Prouduct_Unit-Price Vendor_Address Customer_Telephone GST_Payable Product_Total_Price Vendor_City Customer_Contact_Name PST_Payable Vendor_Postal_Code Vendor_Contact_Name Invoice_Grand_Total Lab Normalization of incomplete tables Name Description Rubric Detail Levels of Achievement Competent Criteria Proficient Identification of tables and columns in 3NF O to 0.35 points Student has identified some tables in 3NF There are se some tables that are not in SNF and some Pks and FKs are Identified 0.35 to 0.75 points Student has identified all tables in SNF and all Pks and FKs are Identified Entity Relationship Diagram 0 to 0.25 points Entity relationship diagram is missing some tables Columns or cardinality with somewhat clarity hence demonstrates limited knowledge of Normalization process 0.25 to 0.5 points Entity relationship diagram is presenting all tables, columns or cardinality with high degree of clarity hence demonstrates excellent inowledge of Normalization process 0 to 0 points Assumptions are clearly made 0 to 0.25 points Assumptions made are clear logical and realistic