Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For each relation table: A. A determine the functional dependencies by examining the below data. B. Determine all keys. C. Determine all Superkeys. same pro

For each relation table: A. A determine the functional dependencies by examining the below data. B. Determine all keys. C. Determine all Superkeys.

image text in transcribed

image text in transcribed

image text in transcribed

same pro write the the sales Table name: LINE Primary key: INV_NUMBER + LINE_NUMBER Foreign key: INV_NUMBER, PROD_CODE NUMBER LINE NUMBER PROD_CODE LINE UNITS LINE PRICE 1001 1 123-21UUY 1001 2 SRE-657UG 1002 1 QER-34256 18.63 1003 1 ZZX/3245Q 6.79 1003 2 SRE-657UG 2.99 1003 3 001278-AB 12.95 1004 1 001278-AB 12.95 1004 2 SRE-657UG 2.99 3 189.99 2.99 the reven comparis transactic will disco Primary key: INV_NUMBER Foreign key: CUS_CODE INV NUMBER CUS CODE INV DATE 1001 10014 08-Mar-12 1002 10011 08-Mar-12 1003 10012 08-Mar-12 1004 10011 09-Mar-12 Table name: PRODUCT Primary key: PROD_CODE Foreign key: none PROD_CODE PROD_DESCRIPT 001278-AB Claw hammer 123-210UY Houselite chain saw, 16-in. bar GER-34256 Sledge hammer, 16-lb. head SRE-657UG Rat-tail file ZZX132450 Steel tape, 12-ft. length 252 PROD_PRICE PROD_ON_HAND VEND_CODE 12.95 23 189.99 235 18.63 231 2.99 6.79 235 15 232 Table name: CUSTOMER Primary key: CUS_CODE Foreign key: none CUS_CODE CUS LNAME CUS FNAME CUS JNITIAL CUS AREACODE CUS PHONE 10010 Ramas Alfred 815 844-2573 10011 Dunne Leona 713 894-1238 10012 Smith Kathy 615 884-2285 10013 Olowski Paul 615 894-2180 10014 Orlando Myron 615 222-1672 10015 O'Brian Amy 713 442-3381 10016 Brown James 615 297-1228 10017 Williams George 615 290-2556 10018 Farriss Anne 713 382-7185 10019 Smith Olette 615 297-3809 im INVOICE

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

More Books

Students also viewed these Databases questions