Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q13. Suppose a PRODUCT table contains two attributes, PROD CODE and VEND_CODE Those two attributes have values of ABC, 125, DEF, 124, GHI, 124, and
Q13. Suppose a PRODUCT table contains two attributes, PROD CODE and VEND_CODE Those two attributes have values of ABC, 125, DEF, 124, GHI, 124, and JKL,123, respectively. The VENDOR table contains a single attribute, VEND CODE, with values 123, 124, 125, and 126, respectively. (The VEND CODE attribute in the PRODUCT table is a foreign key to the VEND CODE in the VENDOR table.) Given that information, what would be the query output for: (6 points) A UNION query based on the two tables? A UNION ALL query based on the two tables? An INTERSECT query based on the two tables? An EXCEPT (MINUS) query based on the two tables? a. b. c. d
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