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:integer, name:string, address:string) Borrowings(isbn:integer, borrower:integer, whenTaken:date, whenReturned:date) Assume the following: • dates are represented as a count of the number of days since Jan 1 1990 • there is a system function today that returns today's date • the relational operators < and > allow you test before and after on dates • all loans are for a period of 14 days • the whenReturned field is null until the book 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.
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:integer, name:string, address:string)
Borrowings(isbn:integer, borrower:integer, whenTaken:date, whenReturned:date)
Assume the following:
• dates are represented as a count of the number of days since Jan 1 1990
• there is a system function today that returns today's date
• the relational operators < and > allow you test before and after on dates
• all loans are for a period of 14 days
• the whenReturned field is null until the book 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.
Step by step
Solved in 2 steps with 2 images
