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, 22.06.2019 03:00, Emanuelle7843

Which action describes an aspect of technological design?

Answers: 1

continue

Computers and Technology, 23.06.2019 04:31, Remba

Q14 what is most important for you to choose before you build a network? a. private network b. nos c. network media d. network protocol e. directory service

Answers: 1

continue

Computers and Technology, 24.06.2019 02:30, journeyhile5

How to apply the fly in effect to objects on a slide

Answers: 1

continue

Computers and Technology, 24.06.2019 11:00, asiaosterling

The program below has been generalized to read a user's input value for hourlywage. run the program. notice the user's input value of 10 is used. modify that input value, and run again. generalize the program to get user input values for workhoursperweek and workweeksperyear (change those variables' initializations to 0). run the program. monthsperyear will never change, so define that variable as final. use the standard for naming final variables. ex: final int max_length

Answers: 2

continue

You know the right answer?

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