Computers and Technology, 11.10.2020 23:01, artbydi

Consider the following relational schema for a library: member(memb_no, name, dob)
books(isbn, title, authors, publisher)
borrowed(memb_no, isbn, date)
Write the following queries in relational algebra.
A. Find the names of members who have borrowed any book published by "McGraw-Hill".
B. Find the names of members who have borrowed all books published by "McGraw-Hill".
C. Find the name and membership number of members who have borrowed more than five different books published by "McGraw-Hill".
D. For each publisher, find the name and membership number of members who have borrowed more than five books of that publisher.
E. 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.

Answers: 2

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 21.06.2019 15:30, sammuelanderson1539

Which function in spreadsheet software can be used to predict future sales or inventory needs?

Answers: 2

continue

Computers and Technology, 22.06.2019 04:30, justbepunky

There is a simple pattern for determining if a binary number is odd. what is it and why does this pattern occur? how many bits would you need if you wanted to have the ability to count up to 1000? how high could you count in binary if you used all 10 of your fingers as bits? (finger up means 1, finger down means 0)

Answers: 3

continue

Computers and Technology, 22.06.2019 18:30, Angelanova69134

Technician a says that a shop towel should never be used to clean around the flange area before replacing an automatic transmission filter. technician b says that a dimpled transmission fluid pan can be repaired. who is right

Answers: 3

continue

Computers and Technology, 22.06.2019 23:00, maxy7347go

Which factor is the most important when choosing a website host? whether customers will make secure transactions the number of email accounts provided the purpose of the website the quality of the host control panel

Answers: 3

continue

Do you know the correct answer?

Consider the following relational schema for a library: member(memb_no, name, dob)
books(isb...