The table R(x,y) currently has the following tuples (note there are duplicates): (1,2), (1,2), (2,3), (3,4), (3,4), (4,1), (4,1), (4,1), (4,2). Compute the result of the query: SELECT R1.x, R2.y, COUNT(*) FROM R R1, RR2 WHERE R1.y = R2.x GROUP BY R1.x, R2.y; Which of the following tuples is in the result? O a. (3, 4, 6) O b. (3, 2, 6) O c. (3, 2, 2) O d. (4, 3, 2)

Question 5 Choose all the correct options about Natural JOINS? |a. The natural join does return all rows from the first table and just the rows with matching values from the second table. | b. Natural joins return only matched columns in the result set. OC. The result of the join is all rows from both tables that have equal values for all matched columns. O d. In the natural join, two tables are joined based on columns that have the same name in both tables.

Consider the table T with two columns (x and y) and the following are the values (x, y) in the table: (1, 2) (2, 3) (3, 4) (4, 1) Which of the following values (x, y) are returned by executing the below query? select a1.x, a2.y from T a1, T a2 where a1.y=a2.x ОА. (3, 1), (4, 2) о В. (1, 2), (2, 3) оС. (1, 2), (3, 4) O D. (1, 3), (2, 4)

Question: Which colleges offer courses?    (Change the SQL query to an relational algebra query.) **Please show the resulting tuples output based on your answer as well in a table for further explanation.  ** SELECT COURSE.COLLEGE FROM COURSE, DEPARTMENT WHERE COURSE.DCODE = DEPARTMENT.DCODE;