Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For the following 3 tables: A(X(PK), Y) B(Z(PK), X(FK)) -- X references A's X C(W(PK), Z(FK)) -- Z references B's Z What would be true
For the following 3 tables:
A(X(PK), Y)
B(Z(PK), X(FK)) -- X references A's X
C(W(PK), Z(FK)) -- Z references B's Z
What would be true of the following query?
SELECT *
FROM A, B, C
WHERE A.X = B.X AND B.Z = C.Z
a. The result has 6 columns
b. The size of the result is 1
c. The size of the result is the size of the largest table (in number of rows)
d. The result has 4 columns
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