Question: Question 5 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

Question 5 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. RUS A. SELECT * FROM R MINUS SELECT * FROM S; 2. Rns 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.RS E. SELECT * FROM R JOIN S ON R.C - S.C: 6.RS F. SELECT * FROM R JOIN S ON R.B = S.B: 7. RDARDS.BS G. SELECT * FROM R UNION SELECT * FROM S; 8. RDAR.C.CS H. SELECT * FROM R INTERSECT SELECT * FROM S: 1 G 2 H 3 A 4 B 5 D 6 7 F E
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
