Lets Two relations
R1(P, Q, R) R2(R, S, T)…….R1 contains 2500 tuples and R2 contains 2000 tuples
Q1)
R1(P, Q, R) R2(R, S, T) ..’R’ is primary key in R1 and R is NOT FK in R2
MIN and MAX tuples in R1 * R2 .. (* ==> Natural Join)
Q2)
R1(P, Q, R) R2(R, S, T) ..’R’ is primary key in R1 and R is FK in R2
MIN and MAX tuples in R1 * R2 .. (* ==> Natural Join)
Q1)
R1(P, Q, R) R2(R, S, T) ..’R’ is NOT primary key in R1 and R is NOT FK in R2
MIN and MAX tuples in R1 * R2 .. (* ==> Natural Join)