Question: Develop a SQL query that will select all of the books that are currently checked out and are past due to be returned, which have
Develop a SQL query that will select all of the books that are currently checked out and are past due to be returned, which have a value greater than $10.00. To find out if a loaned book is past due, you must compare the return date with the current date. Your query must return the name, address, postal code, and phone number of the borrower, the name and phone number of the librarian responsible for the transaction, the date the book was due to be returned, and the name, cost, and ISBN number of the book. You query should sort the list by the return date in descending order which is the oldest date should appear first in the list. You must submit both your SQL query and the output of executing your query against your database. Assignment Instructions: the assignment must include the SQL DML statements required to implement at least the following relations: Book Borrower BookLended Librarian the assignment must make appropriate use of Null (and Not Null) parameters to ensure data validity. The minimum standard will be measured against the instructors example and will be based upon rules associated with primary and foreign keys and integrity constraint rules. the assignment must make appropriate use of constraint clauses to ensure the referential integrity of the relations in the schema. The minimum standard will be measured against the instructors example and will be based upon rules associated with primary and foreign keys and integrity constraint rules. the assignment must make appropriate use of keys including the automatic generation of key values where appropriate.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
