II.

Consider the following schema

Members(Member_id,name,Designation,Age)

Books(Bid,Btitle,Bauthor,Bpublisher,Bprice)

Reserves(Member_id,Bid, Reservedate)

Create the tables along with necessary constraints and insert values appropriately.

Write the following queries in SQL:

1. Find the names of professors older than 35, who reserved the book with title ‘Fundamentals of database Systems’.
2. Create a view that displays the authors and titles of the books reserved on 27-May?2007.
3. Find the names of members who have not reserved any book.
4. Find the number of books and average price of the books published by each publisher.

Note:[ Please update an answer before 12:00 A.M. (-_-) ]