WRITE IN SQL STATEMENTS

Book(bookID, ISBN, title, author, publish-year, category) Member(memberlD, lastname, firstname, address, phone-number, limit) CurrentLoan memberID, bookID, loan-date, due-date) History(memberID, bookID, loan-date, return-date) Members can borrow books from the library. The number of books they can borrow is limited by the "limit" field of the Member relation (it may differ for different members). The category of a book includes fiction, non-fiction, children's and reference. The CurrentLoan table represents the information about books that are currently checked out. When the book is returned to the library, the record will be removed from CurrentLoad relation, and will be inserted into History relation with the return-date. A library may have more than one copy of the same book, in which case each copy has its own bookID, but all copies share the same ISBN