Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Database Question Using the invoice table structure shown below, do the following: CUS CODE UNIT INVOICE INVOICE QUANTITY PRICE(S VENDOR CUS FNAME CUS LNAME CUS

Database Question

image text in transcribed

Using the invoice table structure shown below, do the following: CUS CODE UNIT INVOICE INVOICE QUANTITY PRICE(S VENDOR CUS FNAME CUS LNAME CUS PHONE END CODE PHONE PROD CODE PRODUCT NUM DATE QER34256 Sledge hammer, 16-b. 0011 Leona 10011 Leona 10011 Leona 10012 Kathy 10012 Kathy 10012 Kathy Dunne ( Dunne Dunne Smith Smith Smith 713)894-1238 1002 08-03-2014 (713)894-1238 1004 09-03-2014 (713)894-1238 004 (615)894-2285 1003 08-03-2014 (615)894-2285 1003 08-03-2014 (615)894-2285 1003 08-03-2014 231 (615)123-4536 SRE-657UG at-tail file 0128-ABClaw hammer ZZX32450 Steel tape, 12-ft. length 001278-AB Claw hammer SRE-657UG Rat-tail file 232 (608)224-2134 232 (608)224-2134 235 (615)899-3425 232 (608)224-2134 232 (608)224-2134 235 (615)899-3425 113 Houselite chain saw, 16-in. bar 10014 Myrn 10014 Myron 1 190 Orlando (615)222-1672 1001 08-03-2014 Orlando(615)222-1672 1001 08-03-2014 123-21UUY SRE-657UG Rat-tail file 232 (608)224-2134 Write the relational schema Draw its dependency diagram and identify all dependencies o Include 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)

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

DB2 9 For Linux UNIX And Windows Advanced Database Administration Certification Certification Study Guide

Authors: Roger E. Sanders, Dwaine R Snow

1st Edition

1583470808, 978-1583470800

More Books

Students also viewed these Databases questions