Using the invoice table structure shown below, do the following: CUS CODE INVOICE INVOICE NUM DATE UNIT PRICE(S VENDOR cus FNAME CUSLNAME CUSPHONE VEND CODE PHONE QUANTITY PROD CODE PRODUCT - , 0011 Leona 10011 Leona 10011 Leona 10012 Kathy 10012 Kathy 10012 Kathy ER2Sledge hammer, 16-b. SRE-657UG Rat-tail file 001278-AB Claw hammer ZZX3245Q Steel tape, 12-ft. length 001278-AB Claw hammer SRE-657UG Rat-tail file 2 19 (713)894-1238 1002 08-03-2014 1004 09-03-2014 (713)894-1238 1004 09-03-2014 (615)894-2285 1003 08-03-2014 615)894-2285 1003 08-03-2014 615)894-2285 1003 08-03-2014 Dunne 231 (615)123-4536 head Dunne (713894-1238 Dunne Smith Smith Smith 232 (608)224-2134 232 (608)224-2134 235 (615)899-3425 232 (608)224-2134 232 (608)224-2134 235 (615)899-3425 1 13 Houselite chain saw, 16-ir. 10014 Myro 10014 Myron 1 190 rlando (615222-1672 1001 08-03-2014 Orlando(615)222-1672 1001 08-03-2014 123-21UUY SRE-657UG Rat-tail file 232 (608)224-2134 * Remove all transitive dependencies Write the relational schema, and draw the new dependency diagrams. * Identify the normal forms for each table structure you created. You can assume that the table does not contain repeating groups and that any invoice number may reference more than one product. (Hint: This table uses a composite primary key.)