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.

Reviews

Write a Review

Other Subject Questions & Answers

  Determining moral responsibility

Under what situation can human beings be held morally responsible for what they do? If our actions are determined by other influences, does that get us off the hook, or should we accept responsibility even in cases where we could not have done oth..

  Nature of the judicial process

In his lecture "The Nature of the Judicial Process," Justice Benjamin N. Cardozo said, "(The judge) fills the open spaces in the law.

  Degree freedom analysis

A hydrocarbon feed consisting of a mixture of 20 wt% propane, 30 wt% isobutene, 20 wt% isopentane, and 30 wt% n-pentane is fractionated at a rate of 1000 kmol/hr into a distillate that contains all the propane and 78% of the isopentane in the feed. T..

  Growth in international business activity

Obviously the employ of different national currencies creates a barrier to further growth in international business activity, but what are the pros among companies of replacing national currencies with regional currencies?

  Perception of musical rhythm at birth

Several researchers believe that an infant in utero can hear sounds which it is influenced by parents playing music or reading aloud.

  Impact an individual ability to recognize objectives

There are many factors that impact an individual's ability to recognize objectives. These factors include orientation. There have been some studies that have demonstrated that orientation has relatively little effect on object recognition.

  Cardiac concerns arise when hypertension is a factor

It's obvious that cardiac concerns arise when hypertension is a factor, and this is a direct correlation to heart failure?

  Management staff when dealing with health care issues

What are the perspectives and responsibilities of the financial management staff when dealing with health care issues?

  Movement toward secession in the winter of 1860-1861

The movement toward secession in the winter of 1860-1861 was most rapid in...

  Role of needs assessment in evaluation plan

Critically discuss why a needs assessment was performed at the beginning phases of program development. Analyze the role of the needs assessment in your evaluation plan.

  Important concept about critical thinking for person

Critically discuss the most important concept about critical thinking for a person? What tools/insights does critical thinking give someone to make positive change in their life?

  International business cultural differences

How are Japanese companies able to compete with American companies despite their different approaches to business? Do the Japanese know more about us than we do about them?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd