Find average number of books borrowed from database table

Assignment Help Database Management System

Reference no: EM1364797

Consider the following relational schema for a library:

member(memb_no,name,dob)
books(isbn,title,authors,publisher)
borrowed(memb_no,isbn,date)

Write eh 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 book published by "McGraw-Hill".
c. Find the name and membership number of members who have borrowed more than five books published by "McGraw-Hill".
d. Find the name and membership number of members who have borrowed more than five different 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.

Reference no: EM1364797

Questions Cloud

How to assume the protons started from very far away : how to Assume the protons started from very far away. Need X and Y componet.

All about quantitative reasoning for business : What are two examples of how simultaneous equations are used in business? What are some of the different ways you can satisfy these equations?

Describe how each component of your model lends : Describe how each component of your model lends itself to optimal employee performance and Develop a coaching model that optimizes performance management activities.

Depreciation and book value of investment : Determine the depreciation and book value for each of the two investment groups for each year. Determine the gain/loss for tax purposes If the Group 5 and Group 7 assets are sold at the end of the planning period for a combined $500,000.

Find average number of books borrowed from database table : 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.

Weaknesses are defined as constraints : Weaknesses are defined as constraints - How does below theory apply to your current or most recent employer?

Exchanging dollars for euro : If I plan to go to Germany thirty days and the spot exchange rate is $1.30=1 euro. The thirty day forward rate is $1.36=1 euro.

Government in health care policy formulation : Describe the relationship between the state and the federal government in health care policy formulation and implementation.

What is the distance of closest approach of the two particle : what is the distance of closest approach of the two particles. explain two ways in which you could you this equipment to raise the crate.

User Account

All Pages