Relational schema for a library

Assignment Help Other Subject

Reference no: EM13206755

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

Questions Cloud

With what velocity does the sandbag strike the ground : Neglect air resistance and use g = 32 feet per second per second for the acceleration due to gravity. With what velocity does the sandbag strike the ground?

Analyze causes of anorexia in hospitalized patients : Provide three patient scenarios that commonly result in decreased food intake during prolonged hospitalizations. For each scenario:

How much will the population increase in the first 10 years : Area of base Height. Where P is the number in the population at time t years after some starting date. How much will the population increase in the first 10 years?

Determine what your minimum monthly payment will be : Assume that when you graduate you will owe a total of $29,500 in student loans. Assume that the interest rate is 7.5%, compounded monthly, and that the entire amount must be repaid within 10 years. Determine what your minimum monthly payment will ..

Relational schema for a library : Find the names of members who have borrowed any book published by "McGraw-Hill".

Find the growth constant for the culture : How many bacteria will be in the culture after 7 hours? 1 5. (4 points each) Consider the function f (x) = x + . x (a) What is the domain of the function?

Information systems management class : Think of a recent change that occurred at your college, in your community, or in the news. Use the three-sphere model for systems management and brainstorm issues related to the change based on the business, technology, and organization spheres.

What is the number in cell a3 : What is the number in cell A3? Use mental math to find the sum of each row, column, and diagonal. What did you discover about all of the sums?

Determine the kentons balance sheet as of january : Kenton Limited began retail operations on January 1, 2008. On that date it issued 10,000 shares of common stock for £50,000. On January 31, Kenton used £48,000 of the proceeds to rent a store, paying in advance for the next two years.

User Account

All Pages