Answered step by step
Verified Expert Solution
Link Copied!

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Creating A Database In Filemaker Pro Visual QuickProject Guide

Authors: Steven A. Schwartz

1st Edition

0321321219, 978-0321321213

More Books

Students also viewed these Databases questions

Question

Interact with others without being asked what country you are from?

Answered: 1 week ago