Q1. For the given relations:
Members (mid, name, design, age)
Books (Bid, Btitle, BAuthor, Bpublisher, Bprice)
Reserves (mid, Bid, date)
Here, Bid is book identification, Btitle is Book title, Bpublisher is bookpublisher,
Bprice is Book price, mid is Members identification and Desig is designation.
Now write down the queries in relational algebra to:
a) List out the title of books reserved by the Professors older than 45 years.
b) Determine ids of members who have not reserved books costing more than Rs. 500.
c) Find out the author and title of the books reserved on 27-May-2007.
d) Determine the names of members who have reserved all the books.
Q2. In a tuple relational calculus query with n tuple variables, determine the typical minimum number of join conditions? Explain why? Illustrate the effect of having a smaller number of join conditions?