Consider relations r(A, B) and s(B, C). Assume that r contains 200 records, and that s contains 500 records. Without any further assumptions, what is the maximum number of tuples that r JOINr.B = s.B s can have?
A. 200
B. 100000
C. 500
D. 700
Answer:B
Consider relations r(A, B) and s(B, C). Assume that r contains 200 records, and that s contains 500 records. Without any further assumptions, what is the maximum number of tuples that r JOINr.B = s.B s can have?
A. 200 B. 100000 C. 500 D. 700