Item Qty 2. Invoice Use the Invoice table structure shown below to answer the following questions: INVOICE Cust Retail INVN Custid Petid ItemID Cust Phone Purchase Desc Name aty PetName Breed Price Purchased date T10 C455 P81 112 Collar Elliot 55587769871 9.57 15 1 12/15/2015 Digger Lab T23 C623 P52 164 Toy DuBarry5550897543 3.29 45 2 1/5/2016 Nubs Beagle 0 C455 1413 Leash Elliot 55587769871 14.98 34 2 12/15/2015 Digger Lab C138 278 1511 Dish Travers 5554379533 8.55 25 2 11/25/2015 Snuggles Poodle T9 C205 P94 Chews Allen 5552659980 5.99 86 5 11/30/2015 Snoops Hound P81 T16 183 a) Draw the dependency diagram identifying all dependencies (given/hidden). You can assume that the table does not contain repeating groups (INF). b) Improve the relation to 2NF. Show the new FDs and all dependency arrows. Identify the primary keys. c) improve to 3NF. Show the new FDs and all dependency arrows. Identify the primary keys. d) Draw the relational schema for the final database table structure. Identify all primary/foreign keys