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

🎓 Coach ⭐ 103.11K Points

📊 Database Management System (DBMS)

Q. 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

💬 Discuss

✅ Correct Answer: (B) Selects all the tuples from the natural join of book and borrow wherever the year is lesser than 2009

You must be Logged in to update hint/solution

💬 Discussion

👁️

835

Total Visits

📽️

2 y ago

Published

🎖️

Mr. Dubey

Publisher

📈

90%

Success Rate