Consider relations(tables) R(A, B, and S(B, D). Which of the given SQL queries are equivalent to the Relational Algebra expression "ΠA, R.B, C, S.B, D(R X S)"?
A. SELECT * FROM R, S;
B. SELECT * FROM R, S WHERE R.B = S.B;
C. SELECT A, R.B, C, S.B, D FROM R, S;
D. SELECT A, R.B, C, D FROM R, S WHERE R.B = S.B;
Answer:B
Consider relations(tables) R(A, B, and S(B, D). Which of the given SQL queries are equivalent to the Relational Algebra expression "ΠA, R.B, C, S.B, D(R X S)"?
A. SELECT * FROM R, S; B. SELECT * FROM R, S WHERE R.B = S.B; C. SELECT A, R.B, C, S.B, D FROM R, S; D. SELECT A, R.B, C, D FROM R, S WHERE R.B = S.B;