Given the relation schema R(A, B, C) and S(C, D, E), please match each of the following relational algebra expressions to the corresponding SQL (Structured Query Language) statement.

(Assume R and S are union compatible)

1. R S A. SELECT * FROM R

MINUS

SELECT * FROM S;

2. R S B. SELECT * FROM S

MINUS

SELECT * FROM R;

3. R S C. SELECT * FROM R CROSS JOIN S;

4. S R D. SELECT * FROM R NATURAL JOIN S;

5. R * S E. SELECT * FROM R JOIN S ON R.C = S.C;

6. R S F. SELECT * FROM R JOIN S ON R.B = S.B;

7. R R.B=S.BS G. SELECT * FROM R

UNION

SELECT * FROM S;

8. R R.C=S.CS H. SELECT * FROM R

INTERSECT

SELECT * FROM S;

Transcribed image text