Answered step by step
Verified Expert Solution
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.
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
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