The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of ebooks. FACT is a collection of current technology ebooks for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book, which gives them exclusive access to the book online through the FACT website, but only one patron at a time can have access to a book. A book must have at least one author but can have many. An author must have written at least one book to be included in the system but may have written many. A book may have never been checked out but can be checked out many times by the same patron or different patrons over time. Because all faculty and staff in the department are given accounts at the online library, a patron may have never checked out a book or they may have checked out many books over time. To simplify determining which patron currently has a given book checked out, a redundant relationship between BOOK and PATRON is maintained.
The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of ebooks. FACT is a collection of current technology ebooks for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book, which gives them exclusive access to the book online through the FACT website, but only one patron at a time can have access to a book. A book must have at least one author but can have many.
An author must have written at least one book to be included in the system but may have written many. A book may have never been checked out but can be checked out many times by the same patron or different patrons over time. Because all faculty and staff in the department are given accounts at the online library, a patron may have never checked out a book or they may have checked out many books over time. To simplify determining which patron currently has a given book checked out, a redundant relationship between BOOK and PATRON is maintained.
(1) Write a query to display the checkout number, patron’s name (collated), book title, author’s name (collated), checkout date, and due date for every checkout that has ever occurred in the system by a faculty patron. Sort the results by checkout date in descending order.
(2) Show query result of question #1
(3) Write a query to display the book number, title, year of publication, subject, and cost for all books that are on the subjects of “Middleware” or “Cloud,” and that cost more than $70.
(4) Show query result of question #3
(5) Write a query to display the subject and the number of books in each subject. Sort the results by the number of books in descending order, then by subject name in ascending order.
(6) Show query result of question #5
(7) Write a query to display the author ID and the number of books written by that author. Sort the results in descending order by number of books, then in ascending order by author ID.
(8) Show query result of question #7
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images