Choose The Option That Correctly Explains In Words The Function #572
Choose the option that correctly explains in words, the function of the following relational algebra expression<br /> σyear≥2009 (book ⋈ borrow)
This multiple choice question (MCQ) is related to the book/course gs gs114 Relational Database Management System. It can also be found in gs gs114 Introduction to Relational Model and SQL - Introduction to the Relational Model - Quiz No.1.
Choose the option that correctly explains in words, the function of the following relational algebra expression
σyear≥2009 (book ⋈ borrow)
σyear≥2009 (book ⋈ borrow)
Selects all tuples from the Cartesian product of book and borrow
Selects all the tuples from the natural join of book and borrow wherever the year is lesser than 2009
Selects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009
Selects all tuples from the Cartesian product of book and borrow wherever the year is greater than or equal to 2009