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?
Check out a sample textbook solutionChapter 3 Solutions
DATABASE SYSTEM CONCEPTS (LOOSELEAF)
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education