(a) Based on the table given above provide the relevant relational algebra operations that is been described...
Fantastic news! We've Found the answer you've been seeking!
Question:
(a) Based on the table given above provide the relevant relational algebra operations that is been described in the following statements:
i. List all employees in the library whose salaries are greater than 2000.00.
ii. Produce a list of students, showing only the student id, name, and contact number.
iii. List the book title and publisher that students had borrowed (No title should be repeated).
(b) Using the Book, Student, Staff, and Borrow tables above, derive the output of the following relation algebra operation:
i. Publisher = Oxford AND pubYear >=2005 (BOOK)
ii. "title, author, publisher (Book)
Result1
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date: