Question
Think following relational schema for a library-
member(memb_no,name,dob)
books(isbn,title,authors,publisher)
borrowed(memb_no,isbn,date)
Write following queries in relational algebra.
a. discover names of members who have borrowed any book published by "McGraw-Hill".
b. discover the names of members who have borrowed all book published by "McGraw-Hill".
c. discover the name and membership number of members who have borrowed more than 5 books published by "McGraw-Hill".
d. discover the name and membership number of members who have borrowed more than 5 different books of that publisher.