Question: Consider the library database of Figure 3.20.Write the following queries in SQL. a. Find the member number and name of each member who has borrowed

Consider the library database of Figure 3.20.Write the following queries in SQL.

a. Find the member number and name of each member who has borrowed at least one book published by “McGraw-Hill”.

b. Find the member number and name of each member who has borrowed every book published by “McGraw-Hill”.

c. For each publisher, find the member number and name of each member who has borrowed more than five books of that publisher.

d. Find the average number of books borrowed per member. Take into account that if a member does not borrow any books, then that member does not appear in the borrowed relation at all, but that member still counts in the average.

Figure 3.20 member(memb_no, name) book(isbn, title, authors, publisher) borrowed (memb_no, isbn, date)

member(memb_no, name) book(isbn, title, authors, publisher) borrowed (memb_no, isbn, date)

Step by Step Solution

★★★★★

3.45 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Find the member number and names of each member who has borrowed at least one book published by Mc... View full answer

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 Database System Concepts Questions!

Consider the LIBRARY database schema shown in Figure 4.6. Write PHP code to create the tables of this schema. Figure 4.6 Figure 4.6 A specialization lattice with shared subclass ENGINEERING_MANAGER....

Write the following queries in relational algebra, using the university schema. a. Find the ID and name of each instructor in the Physics department. b. Find the ID and name of each instructor in a...

Write the following queries in SQL, using the university schema. a. Find the ID and name of each student who has taken at least one Comp. Sci. course; make sure there are no duplicate names in the...

Consider the library database of Figure 3.21. Write the following queries in SQL. a. Print the names of members who have borrowed any book published by "McGraw-Hill". b. Print the names of members...

ANSWER IN SQL PLEASE :) answer a-d please member (memb_no, name, age) book(isbn, title, authors, publisher) borrowed (memb_no, isbn, date) 21 Consider the library database of Figure 3.21. Write the...

Consider the library database of Figure 3.20. Write the following queries in SQL. a. Find the member number and name of each member who has borrowed at least one book published by McGraw-Hill. b....

Consider the following relational schema for a library: Tmember ( memb no , name, dob ) books ( isbn , title, authors, publisher ) borrowed ( memb no , isbn, date ) Write the following queries in...

member(memb no, name) book(isbn, title, authors, publisher) borrowed(memb no, isbn, date) Consider the library database above. Write the following queries in SQL. i. Find the member number and name...

2. a. Consider the library database member(memb no, name) book(isbn, title, authors, publisher) borrowed(memb no, isbn, date) Write the following queries in SQL. a. Find the member number and name of...

Part-I Write the following queries in SQL, using the relational database below: book( book-id , title, publisher-name) book-authors( book-id , author-name) publisher publisher-name, address, phone)...

Which of the following is not a strategy for finding P-values with the Student t distribution? Choose the correct answer below. OA. Use a TI-83/84 Plus calculator to find the P-value rounded to at...

Find an equation for a circle satisfying the given conditions. (a) Center (-7, -1), radius of length 9 / 5 (b) Center (0, 3), diameter of length 5

PROBLEM 10-2. Master Budget Techlabs operates a computer training center. The following data relate to the preparation of a master budget for January of 2007. 1. At the end of 2006, the company's...

What is the balance in your life between discretionary and nondiscretionary time? Which do you have more of? Often holidays and summers offer drift time. Is this true in your case? If so, do you...

Using the relations of our sample bank database, write an SQL expression to define the following views: a. A view containing the account numbers and customer names (but not the balances) for all...

For each of the views that you defined in Exercise 6.10, explain how updates would be performed (if they should be allowed at all).

In Chapter 3, we described the use of views to simplify access to the database by users who need to see only part of the database. In this chapter, we described the use of views as a...

An investor receives a loan of 4,000 USD, which is to be repaid by level monthly instalments of 100 USD, payable in arrear over a period of four years. If the flat rate of interest is 5%. APR is...

You are chairperson of the investment fund for the Continental Soccer League. You are asked to set up a fund of semiannual payments to be compounded semiannually to accumulate a sum of $400,000 after...

The partnership of Winn, Xie, Yang, and Zed has the following balance sheet: Cash $ 36,000 Liabilities $ 46,000 Other assets 242,000 Winn, capital (50% of profits and losses) 66,000 Xie, capital...