In this assignment, you will write relational schemas and draw dependency diagrams normalizing data to 3NF. Once you have normalized your tables to 3NF you will create the ER diagram showing the tables and relationships. Instructions Using the table below, complete the following tasks: INVOICE VEND INV_NUM PROD_NUM SALE_DATE PROD_LABEL CODE QUANT. PROD VEND_NAME SOLD PRICE 211347 AA- E3422QW 15-JAN- 2016 Rotary sander 211 Neverfail, Inc. 1 $49.95 0.25-in. drill 211347 QD- 300932x 15-JAN- 2016 211 Neverfail, Inc. 8 $3.45 bit 211347 RU- 995748G 15-JAN- 2016 Band saw 309 BeGood, Inc. 1 $39.99 211348 AA- E34220W 15-JAN- 2016 Rotary sander 211 Neverfail, Inc. 2 $49.95 211349 GH- 778345P 16-JAN- 2016 Power drill 157 Tough Go, Inc. 1 $87.75 1. Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies in 1NF. You can assume that the table does not contain repeating groups and that an invoice number references more than one product. (Hint: This table uses a composite primary key.) 2. Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams normalizing to 2NF. Identify the normal forms for each table structure you created. 3. Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams, normalizing to 3NF. Also, identify the normal forms for each table structure you created. 4. Draw the Crow's Foot ERD. 5. Submit your.vsdx Visio file containing all dependency diagrams and relational schemas for 1NF, 2NF, and 3NF as well as the Crow's feet ER diagram grading.