Reference no: EM13910370
Consider the following relational schema for a library:member(memb no, name, dob)books(isbn, title, authors, publisher)
borrowed(memb no, isbn, date)Write the following queries in relational algebra.a. Find the names of members who have borrowed any book publishedby "McGraw-Hill".b. Find the name of members who have borrowed all books publishedby "McGraw-Hill".
c. Find the name and membership number of members who have borrowedmore than five different books published by "McGraw-Hill".
d. For each publisher, find the name and membership number of memberswho have borrowed more than five books of that publisher.
e. Find the average number of books borrowed per member. Take intoaccount that if an member does not borrow any books, then that
member does not appear in the borrowed relation at all.
|
What are the ethical pros and cons of allowing individuals
: What are the ethical pros and cons of allowing individuals to live their lives of their own choosing even when it results in an increasing chronic illness burden to society?
|
|
Describe the graph of ph values
: Describe the graph of pH values over the course of the reaction in Part II. Was the change in pH consistent over the course of the reaction? Do your best to explain the reason for the shape of the pH curve in your own words.
|
|
Attribute employees most want to see in their managers
: Research consistently indicates that the attribute employees most want to see in their managers is-freedom-honesty-passion-hard work-none of the above
|
|
What is the exercise price of the conversion feature
: An investor come to you and states that she has the option of converting her $2000 XYZ Corporate Bond into 20.50 shares of XYZ common stock. If the XYZ Bond pays a coupon rate of 5.25%, has a call price of 105, and matures in 7 years, what is the ..
|
|
Relational schema for a library:member(
: Consider the following relational schema for a library:member(memb no, name, dob)books(isbn, title, authors, publisher)borrowed(memb no, isbn, date)Write the following queries in relational algebra.a. Find the names of members who have borrowed any b..
|
|
What is the deductibility of brenda contribution
: Where on her tax form would Brenda take the advertising expense? Would Brenda's decision to use accrual or cash accounting impact her inventory? Why or why not?
|
|
Design and analysis of a motorcycle rear suspension
: The first element is to conduct research into the geometry of a typical motorcycle suspension and specify a typical wheel diameter and sprung mass - Your design should clearly show the joints you have chosen, and you should justify your choices. T..
|
|
Determining the volume of solution
: Volume of solution is 350 cubic centimeters. It contains 0,12 moles of sodium bicarbonate and 0.08 moles of sodium carbonate. How to calculate pH of such solution?
|
|
Analyze the complexities of the derivative markets
: Discuss the difficulties that having options in a security portfolio create for the measurement of portfolio risk. Suggest how the standard deviation statistic should be modified to account for this concern.
|