- write down the relational expressions for the followingqueries: a. How many co

Question

- write down the relational expressions for the followingqueries: a. How many copies of the book titled The LOst Tribe are ownedby the libarary branch whose name is 'Sharpstown'? b.How many copies of the book Titlrd The Lost Tribe are ownedby each libarary branch? c. Retrieve the names of all borrowers who do not have anybooks checked out. d. For each book that is loaned out from the Sharpstown branchand whose Due_date is today, retrieve the book title, theborrower's name, and the borrower's address. e. For each libarary branch, retrieve the branch name and thetotal number of books loaned out from that branch. f. Retieve the names, addresses, and number of books checkedout for all borrowers who have more than five books checkedout. g. For each book authored (or coauthored) by stephen King,retrieve the title and the number of copies owned by the libararybranch whose name is Central. GOOD LUCK :) - write down the relational expressions for the followingqueries: a. How many copies of the book titled The LOst Tribe are ownedby the libarary branch whose name is 'Sharpstown'? b.How many copies of the book Titlrd The Lost Tribe are ownedby each libarary branch? c. Retrieve the names of all borrowers who do not have anybooks checked out. d. For each book that is loaned out from the Sharpstown branchand whose Due_date is today, retrieve the book title, theborrower's name, and the borrower's address. e. For each libarary branch, retrieve the branch name and thetotal number of books loaned out from that branch. f. Retieve the names, addresses, and number of books checkedout for all borrowers who have more than five books checkedout. g. For each book authored (or coauthored) by stephen King,retrieve the title and the number of copies owned by the libararybranch whose name is Central. GOOD LUCK :)

Explanation / Answer

Here Query would be to do the SELECTs before the JOIN operationfollows.

RESULT   PROJECT Name (BORROWER *NO_CHECKOUT_B)

Note:-

S PROJECT Branch Id (select Branch Name =‘Sharps town’ (LIBRARY_BRANCH))

B_FROM_S PROJECT BOOK Id. Card NO ((select Due. Date =‘today’ (BOOK LOANS)) * S)

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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