Question

consider the following typed relational schema describing books and borrowers in a library:

Book (isbn:integer,title:string:publisher:string,year:integer)

Author(isbn:integer,name:string,rank:integer)

Borrower:(bid:ineger,name:string,address:string)

Borrowings:(isbn:integer,borrower:integer,whenTaken:date, whenReturn:date)

Assume the following:

.dates are represented as a count of the number of days since Jan 11990

.there is a system function today that returns today's date

.the relational operators allows you test before and after on dates

.all loans are for period of 14 days

.the whenReturned fields is null till the books is returned

.the rank field specifies whether the author is the first, second, third,...author

implement solutions to the following:

Write an SQL query to list each overdue book (title) and the borrower's name.