Question

Create database of library (book_id,book_name,author,book_status,date_of_issue,date_of_return,reference or leading book issued).
(Hint:book status mean books of leading and reference (len/ref).
i) Create a suitable primary key and enter at least five records with difference names.
Write Queries
ii) Display list of books which are not for leading.
iii) Find list of books issued.
iv) Display list of books issued between to dates.(issue date,return date).
v) Display list of books with same author.