Choose the option that correctly explains in words, the function of the following relational algebra expression
year 2009 (book borrow)

Question

Choose the option that correctly explains in words, the function of the following relational algebra expression year 2009 (book   borrow)

TuteeHUB · Accepted Answer

tSelects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009

TuteeHUB · Answer

tSelects all tuples from the Cartesian product of book and borrow

TuteeHUB · Answer

tSelects all the tuples from the natural join of book and borrow wherever the year is lesser than 2009

TuteeHUB · Answer

tSelects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009

TuteeHUB · Answer

tSelects all tuples from the Cartesian product of book and borrow wherever the year is greater than or equal to 2009

1.	Choose the option that correctly explains in words, the function of the following relational algebra expression year 2009 (book borrow)
A.	tSelects all tuples from the Cartesian product of book and borrow
B.	tSelects all the tuples from the natural join of book and borrow wherever the year is lesser than 2009
C.	tSelects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009
D.	tSelects all tuples from the Cartesian product of book and borrow wherever the year is greater than or equal to 2009
Answer» C. tSelects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009

Discussion