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

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: o Book o Borrower o BookLended o 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 instructor's 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 instructor's 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!