Question

1 Approved Answer

Posted on Sep 08, 2024

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

image text in transcribed

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. d).Draw the Crow's Foot ERD CUS CODE NVOICE INVOICE QUANTITY PRICE!S) UNIT CUS FNAME CUS LNAME CUS PHONE VEND CODE VENDOR PROD CODE PRODUCT NUM DATE PHONE QER34256 Sledge hammer, 16-b. SRE-657UG Rat-tail file 001278-AB Claw hammer Zz/3245Q Steeltape, 12-ft. length 001278-AB Claw hammer SRE-657UG Rat-tail file 2 19 0011 Leona 10011 Leona 0011 Leona 10012 Kathy 10012 Kathy 10012 Kathy Dunne (713)894-1238 1002 08-03-2014 (713)894-1238 1004 09-03-2014 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 rano (615222-1672 1001 08-03-2014 231 (615)123-4536 head 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 713)894-1238 Smith Smith 1 13 Houselite chain saw, 16-in. 0014 Myron 1 190 123-21UUY 10014 Myron Orlando(615)222-1672 1001 08-03-2014 SRE-657UG Rat-tail file 232 (608)224-2134 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. d).Draw the Crow's Foot ERD CUS CODE NVOICE INVOICE QUANTITY PRICE!S) UNIT CUS FNAME CUS LNAME CUS PHONE VEND CODE VENDOR PROD CODE PRODUCT NUM DATE PHONE QER34256 Sledge hammer, 16-b. SRE-657UG Rat-tail file 001278-AB Claw hammer Zz/3245Q Steeltape, 12-ft. length 001278-AB Claw hammer SRE-657UG Rat-tail file 2 19 0011 Leona 10011 Leona 0011 Leona 10012 Kathy 10012 Kathy 10012 Kathy Dunne (713)894-1238 1002 08-03-2014 (713)894-1238 1004 09-03-2014 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 rano (615222-1672 1001 08-03-2014 231 (615)123-4536 head 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 713)894-1238 Smith Smith 1 13 Houselite chain saw, 16-in. 0014 Myron 1 190 123-21UUY 10014 Myron Orlando(615)222-1672 1001 08-03-2014 SRE-657UG Rat-tail file 232 (608)224-2134