Use the schema below for the following questions: Book (BookId, Title, Publisher-name) BookLoans (BookId, BranchId, CardNo, DateOut, DueDate) BookCopies (BookId, BranchId, No-of-copies) LibraryBranch (BranchId, BranchName, Address) Borrower (CardNo, Name, Address, phone)
i. How many copies of the book titled „The big magic? are owned by the local library whose name is "Newtown" library?
ii. For each book which is loaned out from the „Newtown" branch and whose DueDate is today, retrieve the book title, the borrower?s name and the borrower?s address.