(a) Using the INVOICE table structure given below, do the following questions Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 211348 211349 PROD NUM AA-E34220W D-300932X RU-995748G AA-E34220W GH-778345P SALE DATE 15-Jan-2010 15-Jan-2010 15-Jan-2010 15-Jan-2010 16-Jan-2010 PROD_LABEL Rotary sander 0.25-in. drill Band saw Rotary sander Power drill bit VEND CODE 211 211 309 211 157 VEND NAME NeverFail, Inc. NeverFail, Inc. BeGood, Inc. NeverFail, Inc. ToughGo, Inc. QUANT_SOLD 1 8 1 2 1 PROD PRICE $49.95 $3.45 $39.99 $49.95 $87.75 i) Draw the dependency diagram and identify all the dependencies ii) Create a database whose tables are in 2NF, showing dependency diagram for each table iii) Create a database whose tables are in 3NF, showing dependency diagram for each table. iv) Give the relational schema for the final tables