Find the average number of books borrowed per member

Assignment Help Basic Computer Science

Reference no: EM131058174

Consider the following relational schema for a library:

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 name 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 an member does not borrow any books, then that member does not appear in the borrowed relation at all.

Reference no: EM131058174

Questions Cloud

Huge quantities of gasoline from refineries : Tanker trucks are designed to carry huge quantities of gasoline from refineries to filling stations. A factory that manufactures the tank of the trucks claims to manufacture tanks with a capacity of 8550 gallons of gasoline. The actual capacity of..

Option on multiple regression : Using SCF's SCF2010.sav, you will run a statistical multiple regression on the total amount of financial assets held by households, FIN.

Discuss basic concepts in designing for product excellence : Discuss the basic concepts in designing for product excellence. How can product design effect manufacturability and environmental responsibility?

Depression and drug use : Use these two variables to answer the following questions: Depression and Drug Use.

Find the average number of books borrowed per member : Find the average number of books borrowed per member

Null hypothesis statistical testing : What are the three criticisms of null hypothesis statistical testing?

To study the energy savings : To study the energy savings due to adding solar heating panels to a house, researchers measured the natural gas consumption of the house for more than a year, then installed solar panels and observed the natural gas consumption for almost two year..

System requirements document for course-planning : Requirements Document for Course-Planning - The Administration performs following functions like managing Professors and managing Students and managing Subjects and managing Streams and managing Schedule

Null hypothesis statistical testing : What are the three criticisms of null hypothesis statistical testing?

User Account

All Pages