Find name and membership number of members

Assignment Help Database Management System

Reference no: EM1367446

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: EM1367446

Questions Cloud

Convert data model to a set of virtual windows : You are to design a prototype for a hospital management system. Design a data model for this system, Convert the data model to a set of virtual windows.

Caring code in clinical nursing education : I'm analyzing a research article titled ' application and evaluation of a caring code in clinical nursing education' where the purpose of the study is to determine if a 'caring code'

Illustrate comparison over time of market values of outputs : Illustrate what problem is posed by any comparison over time of market values of various total outputs. How is this problem resolved.

At what two locations on x-axis is the potential zero : A woman on a 10 speed bicycle travels at 9 m/s relative to ground as a she passes a little boy on a tricycle going in the opposite direction. If the boy is travelling at 1m/s relative to the ground, how fast does the boy appear to be moving relati..

Find name and membership number of members : Find the name and membership number of members who have borrowed more than five different books of that publisher.

Illustrate what effect economic and socioeconomic forces : Illustrate what effect might economic and socioeconomic forces within that nation have on product's potential.

Determine current profits : Why do you think firm 1's marginal cost is lower than firm 2's marginal cost? Determine the current profits of the the two firms. What would happen to each firm's current profits if firm 1 reduced its price to $6 while firm continued to charge $8?

Demand and supply analysis : Using demand and supply analysis, answer the questions. Determine the effects on the exchange rate between the British pound and the Japanese yen from:

Learning strategies in a certain sequence : Do you think are the most valuable for your practicum and why? Would you apply the strategies in a certain sequence? If so, what would it be and why?

User Account

All Pages