THANK YOU

Chapter 6- Using the invoice table structure shown below, do the following:* a).Write the relational schema, draw its dependency diagram and identify all dependencies, including all partial and transitive dependencies. 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.)* b). Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created c). Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams. Also identify the normal forms for each table structure you created. UNIT INVOICE INVOICE QUANTITY PRICES) CUS CODE VENDOR CUS FNAME CUS LNAME CUS PHONE END CODE PHONE PROD CODE PRODUCT NUM DATE ER34256 Sledge hammer, 16-b. 0011 Leona 10011 Leona 0011 Leona 10012 Kathy 10012 Kathy 10012 Kathy 231 (615)123-4536 232 (608)224-2134 232 (608)224-2134 235 (615)899-3425 232 (608)224-2134 232 (608)224-2134 235 (615)899-3425 Dunne 7133894-1238 1002 08-03-2014 head Dunne ( Dunne Smith Smith 713)894-1238 1004 09-03-2014 13894-12381004 09-03-2014 615)894-2285 1003 08-03-2014 615)894-2285 1003 08-03-2014 (615)894-2285 1003 08-03-2014 Orlando (615)222-1672 1001 08-03-2014 SRE-657UG Rat-tail fle 01278-ABClaw hammer ZZ32450 Steel tape, 12-f. length 001278-AB Claw hammer SRE-657UG Rat-tail fle 123-21UUY Houselite chain saw, 16in SRE-657UG Rat-tail fle 0014 Myrn 1190 10014 Myron Orano(615)222-1672 1001 08-03-2014 232 (608)224-2134