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 C 1 (31.03 KiB) Viewed 63 times
(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
- The Cis Department At Tiny College Maintains The Free Access To Current Technology Fact Library Of Ebooks Fact Is A C 2 (224.22 KiB) Viewed 63 times
QUESTION 1 8 points Save Answer 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. CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book_Num >------ FK2 Pat_ID Pat FName Check_out_Date Pat_LName Check Due Date Pat Type Check_In_Date BOOK AUTHOR PK Book Num PK Au ID Book Title PO Book_Year Book_Cost Book_Subject FK1 Pat_ID Au_FName Au_LName Au_Birth Year WRITES PK.FK1 Book Num + PK,FK2 Au ID 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. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BI y Paragraph Arial 10pt : A 4 G Q do Q S = = 5 x X2 ܟ ܀ T: 9 & T T - + ABC T " 2 e. Ω FAV X 8 旺田EX 出 用 四 <> (:) © R? E身 +