Question: The following tables form a Library database held in an RDBMS: Borrower (card_no, last_name,first name, address city, state,zip Books (ISBN, title, pub date , pub_id

 The following tables form a Library database held in an RDBMS:

The following tables form a Library database held in an RDBMS: Borrower (card_no, last_name,first name, address city, state,zip Books (ISBN, title, pub date , pub_id , list^price, category_id, pub_id) Categories (category_id, category_desc) Author (author_id, last_name, first_name) Bookauthor (ISBN, author_id) Publisher (pub_id, name, contact, phone) Bookloans (ISBN, branch_id, card_no, date_ out, due_date) Bookcopies (ISBN, branch_id, no_of_copies) Branch (branch_id, branch_nane, city) Write SQL statements to perform the following queries 1. Display the last names and first names of all borrower who do not have any books checked out. Use a subquery. 2. Determine the number of different borrowers who have borrowed books written or co-written by William White. USE a subquery 3. Determine which books were published by the publisher of "Intro to DB Systems-7th Ed " USE a subquery. Display the title column. 4. Display the last name, first name, and address of borrowers who have borrowed a book that was supplied by a publisher with a publisher Name that begins with the letter P. Use a subquery. 5. Determine which books have a list price that is less than or equal the average list price of other books in the same category. Display the title, category id, and list price columns

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!