Question

BOOK Book_id Title Publisher_name BOOK_AUTHORS Book_id Author_name PUBLISHER Name Address Phone BOOK COPIES Book_id Branch_id No_of_copies 1. (40 marks) Consider the LIBRARY relational database schema which is used to keep track of books, borrowers, and book loans. Write down the SQL statement for each of the following queries. (1) Retrieve the names of books that are not borrowed by any one. (2) Find out the borrowers who only borrowed books from the Riverside branch. (3) Find out the borrowers who borrowed books from all branches. (4) Retrieve the average number of books borrowed by each borrower. BOOK LOANS Book_id Branch_id Card_no Date out Due date LIBRARY BRANCH Branch_id Branch name Address BORROWER Card_no Name Address Phone

          BOOK
Book_id Title Publisher_name
BOOK_AUTHORS
Book_id Author_name
PUBLISHER
Name Address Phone
BOOK COPIES
Book_id Branch_id No_of_copies
1. (40 marks) Consider the LIBRARY relational database schema
which is used to keep track of books, borrowers, and book loans.
Write down the SQL statement for each of the following queries.
(1) Retrieve the names of books that are not borrowed by any
one.
(2) Find out the borrowers who only borrowed books from the
Riverside branch.
(3) Find out the borrowers who borrowed books from all
branches.
(4) Retrieve the average number of books borrowed by each
borrower.
BOOK LOANS
Book_id Branch_id Card_no Date out Due date
LIBRARY BRANCH
Branch_id Branch name Address
BORROWER
Card_no Name Address Phone

BOOK
Bookid Title Publishername
BOOKAUTHORS
Bookid Authorname
PUBLISHER
Name Address Phone
BOOK COPIES
Bookid Branchid Noofcopies
1. (40 marks) Consider the LIBRARY relational database schema
which is used to keep track of books, borrowers, and book loans.
Write down the SQL statement for each of the following queries.
(1) Retrieve the names of books that are not borrowed by any
one.
(2) Find out the borrowers who only borrowed books from the
Riverside branch.
(3) Find out the borrowers who borrowed books from all
branches.
(4) Retrieve the average number of books borrowed by each
borrower.
BOOK LOANS
Bookid Branchid Cardno Date out Due date
LIBRARY BRANCH
Branchid Branch name Address
BORROWER
Cardno Name Address Phone

Added by Anthony P.

Question

Please give Ace some feedback