Create the following views using the Where clause; Do not use joins! 9. List the

Question

Create the following views using the Where clause; Do not use joins!

9. List the books owned by each branch with the library number, name, book number, and title.

10. List the current total of past due fees for each library for all books that are still out. Note that this is asummary report. Order by library name. Provide a grand total.

11. List overdue books by patron. Group and order by patron name. Show patron name, patron phone number,book title, due date, late fees per book and per patron. Include a grand total.

COUNTY LIBRARY SYSTEM Use the following relations for the SQL queries for this project. D, LIBRARY NAME, STREETLADDRESS, CITY, STATE, ZIPCODE, PHONE, LIBRARY LIBRARY MANAGER NAME) BRANCH BRANCH ID, BRANCH NAME, STREET ADDRESS, CITY, STATE, ZIPCODE, PHONE, BRANCH MANAGER, LIBRARYLID) FK L BRARY ID LIBRARY (PUBLISHER ID, PUBLISHER NAME, STREETLADDRESS, STATE ZIPCODE, PHONE) CITY, PUBLISHER BOOK BOOK D, BOOK TITLE, PUBLICATION DATE, PUBLISHER ID, PRECIS) FK PUBLISHER ID PUBLISHER (AUTHORID, FIRST NAME, LAST NAME, DATE oF BIRTH, DATE OF DEATH) AUTHOR BOOK AUTHOR BOOK D. AUTHOR ID FK BOOK ID BOOK FK AUTHOR ID AUTHOR COPY ID, BOOK D, COST, BRANCH ID) COPY FK BOOK ID BOOK FK BRANCH ID BRANCH CATEGORY CATEGORY ID, CATEGORY NAME

Explanation / Answer

Sql queries for view creations are given below:

Question 9. List the books owned by each branch with the library number, name, book number, and title.

CREATE VIEW branch_owned_book AS (
SELECT LIBRARY_ID, LIBRARY_NAME FROM LIBRARY
UNION
SELECT BOOK_ID, BOOK_TITLE FROM BOOK
)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.