Q1. For the given relations:
Members (mid, name, design, age)
Books (Bid, Btitle, BAuthor, Bpublisher, Bprice)
Reserves (mid, Bid, date)
Where Bid is book identification, Btitle is the Book title, Bpublisher is the book publisher, Bprice is the Book price, mid is the Members identification and Design is the designation
Write down the given queries in the Relational Algebra:
a) List out the title of books reserved by professors older than 45 years
b) Find out ids of members who haven’t reserved books costing more than Rs. 500.
c) Find out the author and title of books reserved on 27-May-2007.
d) Find out the names of members who have reserved all books.
Q2. Describe the anomalies in a relation which are addressed by the Normalization.