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

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

TuteeHUB · Answer

Selects all tuples from the Cartesian product of book and borrow

TuteeHUB · Answer

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

TuteeHUB · Answer

Selects 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.	Selects all tuples from the Cartesian product of book and borrow
B.	Selects all the tuples from the natural join of book and borrow wherever the year is lesser than 2009
C.	Selects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009
D.	Selects all tuples from the Cartesian product of book and borrow wherever the year is greater than or equal to 2009
Answer» C. Selects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009

Discussion