a. Query: select memb_no, name from member natural join borrowed where isbn in (select isbn from book where publisher=’McGraw-Hill’); Explanation:

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

Chapter 3, Problem 21E

Explanation of Solution

a.

Query:

select memb_no, name from member natural join borrowed where isbn in (select isbn from book where publisher=’McGraw-Hill’);

Explanation:

Explanation of Solution

b.

Query:

Select memb_no, name from member m where not exists

(select isbn from book where publisher=’McGraw-Hill’ except (select isbn from member natural join borrowed where m.memb_no=memb_no));

Explanation:

The above query is get the “memb_n...

Explanation of Solution

c.

Query:

Select memb_no, name from member natural join borrowed natural join book group by memb_no, name, publisher having count (isbn)>5...

Explanation of Solution

d.

Query:

select sum(num_of_books)/ count(memb_no) from (select memb_no, (select count(*) from borrowed where member.memdber_no=borrowed...

Explanation of Solution

e.

Query:

create table participated (report_number char(20) primary key, license char(20) references car, driver_id char(20) references driver, damage_amount dec(6,2) )

Explanation:

The above query is used creat...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Pattern RecognitonDecision Tree please write the steps not only last answer

Pattern RecognitionPCA algorithmplease write the steps not only last answer

Please original work Final Project: Part I Background Information: E-TechMart, established in 2005, has grown to become a leading global electronics retailer, renowned for its extensive range of electronic devices and accessories. With a robust online platform and numerous brick-and-mortar stores spread across various regions, E-TechMart serves millions of customers worldwide. The company's product offerings include the latest smartphones, laptops, tablets, smart home devices, and a variety of electronic accessories, catering to both individual consumers and businesses. E-TechMart has always prioritized customer satisfaction and aims to provide an exceptional shopping experience. This commitment is evident in their comprehensive customer service, competitive pricing, and a well-organized loyalty program that rewards repeat customers. Despite these strengths, E-TechMart faces increasing competition from other major players in the electronics retail market. To maintain its competitive…

Answer 2

Expert Solution & Answer

Chapter 3, Problem 21E

Explanation of Solution

a.

Query:

select memb_no, name from member natural join borrowed where isbn in (select isbn from book where publisher=’McGraw-Hill’);

Explanation:

Explanation of Solution

b.

Query:

Select memb_no, name from member m where not exists

(select isbn from book where publisher=’McGraw-Hill’ except (select isbn from member natural join borrowed where m.memb_no=memb_no));

Explanation:

The above query is get the “memb_n...

Explanation of Solution

c.

Query:

Select memb_no, name from member natural join borrowed natural join book group by memb_no, name, publisher having count (isbn)>5...

Explanation of Solution

d.

Query:

select sum(num_of_books)/ count(memb_no) from (select memb_no, (select count(*) from borrowed where member.memdber_no=borrowed...

Explanation of Solution

e.

Query:

create table participated (report_number char(20) primary key, license char(20) references car, driver_id char(20) references driver, damage_amount dec(6,2) )

Explanation:

The above query is used creat...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

Chapter 3, Problem 21E

Explanation of Solution

a.

Query:

select memb_no, name from member natural join borrowed where isbn in (select isbn from book where publisher=’McGraw-Hill’);

Explanation:

Explanation of Solution

b.

Query:

Select memb_no, name from member m where not exists

(select isbn from book where publisher=’McGraw-Hill’ except (select isbn from member natural join borrowed where m.memb_no=memb_no));

Explanation:

The above query is get the “memb_n...

Explanation of Solution

c.

Query:

Select memb_no, name from member natural join borrowed natural join book group by memb_no, name, publisher having count (isbn)>5...

Explanation of Solution

d.

Query:

select sum(num_of_books)/ count(memb_no) from (select memb_no, (select count(*) from borrowed where member.memdber_no=borrowed...

Explanation of Solution

e.

Query:

create table participated (report_number char(20) primary key, license char(20) references car, driver_id char(20) references driver, damage_amount dec(6,2) )

Explanation:

The above query is used creat...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

Chapter 3, Problem 21E

Explanation of Solution

a.

Query:

select memb_no, name from member natural join borrowed where isbn in (select isbn from book where publisher=’McGraw-Hill’);

Explanation:

Explanation of Solution

b.

Query:

Select memb_no, name from member m where not exists

(select isbn from book where publisher=’McGraw-Hill’ except (select isbn from member natural join borrowed where m.memb_no=memb_no));

Explanation:

The above query is get the “memb_n...

Explanation of Solution

c.

Query:

Select memb_no, name from member natural join borrowed natural join book group by memb_no, name, publisher having count (isbn)>5...

Explanation of Solution

d.

Query:

select sum(num_of_books)/ count(memb_no) from (select memb_no, (select count(*) from borrowed where member.memdber_no=borrowed...

Explanation of Solution

e.

Query:

create table participated (report_number char(20) primary key, license char(20) references car, driver_id char(20) references driver, damage_amount dec(6,2) )

Explanation:

The above query is used creat...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

Chapter 3, Problem 21E

Explanation of Solution

a.

Query:

select memb_no, name from member natural join borrowed where isbn in (select isbn from book where publisher=’McGraw-Hill’);

Explanation:

Explanation of Solution

b.

Query:

Select memb_no, name from member m where not exists

(select isbn from book where publisher=’McGraw-Hill’ except (select isbn from member natural join borrowed where m.memb_no=memb_no));

Explanation:

The above query is get the “memb_n...

Explanation of Solution

c.

Query:

Select memb_no, name from member natural join borrowed natural join book group by memb_no, name, publisher having count (isbn)>5...

Explanation of Solution

d.

Query:

select sum(num_of_books)/ count(memb_no) from (select memb_no, (select count(*) from borrowed where member.memdber_no=borrowed...

Explanation of Solution

e.

Query:

create table participated (report_number char(20) primary key, license char(20) references car, driver_id char(20) references driver, damage_amount dec(6,2) )

Explanation:

The above query is used creat...

Answer 8

Chapter 3, Problem 21E

Explanation of Solution

a.

Query:

select memb_no, name from member natural join borrowed where isbn in (select isbn from book where publisher=’McGraw-Hill’);

Explanation:

Answer 9

Chapter 3, Problem 21E

Explanation of Solution

a.

Query:

select memb_no, name from member natural join borrowed where isbn in (select isbn from book where publisher=’McGraw-Hill’);

Explanation:

Answer 10

Explanation of Solution

b.

Query:

Select memb_no, name from member m where not exists

(select isbn from book where publisher=’McGraw-Hill’ except (select isbn from member natural join borrowed where m.memb_no=memb_no));

Explanation:

The above query is get the “memb_n...

Answer 11

Explanation of Solution

b.

Query:

Select memb_no, name from member m where not exists

(select isbn from book where publisher=’McGraw-Hill’ except (select isbn from member natural join borrowed where m.memb_no=memb_no));

Explanation:

The above query is get the “memb_n...

Answer 12

Explanation of Solution

c.

Query:

Select memb_no, name from member natural join borrowed natural join book group by memb_no, name, publisher having count (isbn)>5...

Answer 13

Explanation of Solution

c.

Query:

Select memb_no, name from member natural join borrowed natural join book group by memb_no, name, publisher having count (isbn)>5...

Answer 14

Explanation of Solution

d.

Query:

select sum(num_of_books)/ count(memb_no) from (select memb_no, (select count(*) from borrowed where member.memdber_no=borrowed...

Answer 15

Explanation of Solution

d.

Query:

select sum(num_of_books)/ count(memb_no) from (select memb_no, (select count(*) from borrowed where member.memdber_no=borrowed...

Answer 16

Explanation of Solution

e.

Query:

create table participated (report_number char(20) primary key, license char(20) references car, driver_id char(20) references driver, damage_amount dec(6,2) )

Explanation:

The above query is used creat...

Answer 17

Explanation of Solution

e.

Query:

create table participated (report_number char(20) primary key, license char(20) references car, driver_id char(20) references driver, damage_amount dec(6,2) )

Explanation:

The above query is used creat...

Answer 18

Expert Solution & Answer

Answer 19

Expert Solution & Answer

Answer 20

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 21

Ch. 3 - Prob. 1PE Ch. 3 - Prob. 2PE Ch. 3 - Prob. 3PE Ch. 3 - Suppose that we have a relation marks(ID, score)...Ch. 3 - Suppose that we have a relation marks(ID, score)...Ch. 3 - The SQL like operator is case sensitive (in most...Ch. 3 - Prob. 7PE Ch. 3 - Prob. 8PE Ch. 3 - Prob. 9PE Ch. 3 - Prob. 10PE

a. Query: select memb_no, name from member natural join borrowed where isbn in (select isbn from book where publisher=’McGraw-Hill’); Explanation:

Explanation of Solution

a. Query: select memb_no, name from member natural join borrowed where isbn in (select isbn from book where publisher=’McGraw-Hill’); Explanation:

Explanation of Solution

b. Query: Select memb_no, name from member m where not exists (select isbn from book where publisher=’McGraw-Hill’ except (select isbn from member natural join borrowed where m.memb_no=memb_no)); Explanation: The above query is get the “memb_n...

Explanation of Solution

c. Query: Select memb_no, name from member natural join borrowed natural join book group by memb_no, name, publisher having count (isbn)>5...

Explanation of Solution

d. Query: select sum(num_of_books)/ count(memb_no) from (select memb_no, (select count(*) from borrowed where member.memdber_no=borrowed...

Explanation of Solution

e. Query: create table participated (report_number char(20) primary key, license char(20) references car, driver_id char(20) references driver, damage_amount dec(6,2) ) Explanation: The above query is used creat...

Want to see the full answer?

Chapter 3 Solutions

a.

Query:

select memb_no, name from member natural join borrowed where isbn in (select isbn from book where publisher=’McGraw-Hill’);

Explanation:

b.

Query:

Select memb_no, name from member m where not exists

(select isbn from book where publisher=’McGraw-Hill’ except (select isbn from member natural join borrowed where m.memb_no=memb_no));

Explanation:

The above query is get the “memb_n...

c.

Query:

Select memb_no, name from member natural join borrowed natural join book group by memb_no, name, publisher having count (isbn)>5...

d.

Query:

select sum(num_of_books)/ count(memb_no) from (select memb_no, (select count(*) from borrowed where member.memdber_no=borrowed...

e.

Query:

create table participated (report_number char(20) primary key, license char(20) references car, driver_id char(20) references driver, damage_amount dec(6,2) )

Explanation:

The above query is used creat...