Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started