Note: if there is many to many relationship exists between entities, it must be resolved. 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. Rubric: 1. Identify partial dependencies and label them. (.5) 2. Identify transitive dependencies and label them. (.5) 3. Draw ERD of the entities in 3NF: a. Label all unique identifiers as PK (.5) b. Correct relationships and labeling all foreign keys (FK). (.5) c. Placement of all attributes at their most logical place by following the database design and normalization rules. (1) Note: if there is many to many relationship exists between entities, it must be resolved. 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. Rubric: 1. Identify partial dependencies and label them. (.5) 2. Identify transitive dependencies and label them. (.5) 3. Draw ERD of the entities in 3NF: a. Label all unique identifiers as PK (.5) b. Correct relationships and labeling all foreign keys (FK). (.5) c. Placement of all attributes at their most logical place by following the database design and normalization rules. (1)