Consider the following relational schema for a librarywrite, Ask an Expert

Engineering

Consider the following relational schema for a library:

Write the following queries in relational algebra.

a. Find the names of members who have borrowed any book published by "McGraw-Hill".

b. Find the name of members who have borrowed all books published by "McGraw-Hill".

c. Find the name and membership number of members who have borrowed more than five different books published by "McGraw-Hill".

d. For each publisher, find the name and membership number of members who have borrowed more than five books of that publisher.

e. Find the average number of books borrowed per member. Take into account that if an member does not borrow any books, then that member does not appear in the borrowed relation at all.

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M91782574

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

Nbspintroduction to software developmentusing only

Introduction to Software Development Using only Flowgorithm program. Please do not answer if you do not know the answer or you are nor sure .... I need only the Flowgorithm program. Rainfall statistics. Design a program ...

Current system analysis and modelling assignment 1

Current System Analysis and Modelling Assignment 1 - Assignment overview - This assignment aims to produce a requirements document that captures the functional requirements for an information system that supports the cur ...

C programminghelp with a program positivec that include the

***C PROGRAMMING*** Help with a program positive.c that include the following function: void extract(int *a, int n, int *positive, int *size); The function should use pointer arithmetic, not subscripting. The extract fun ...

Dog up franks is looking at a new sausage system with an

Dog Up! Franks is looking at a new sausage system with an initial cost of $440,000 that will last for five years. The fixed asset will qualify for 100 percent bonus depreciation in the first year, at the end of which the ...

Question include the following items in your paper and

Question: Include the following items in your paper and formal presentation: • A description of the Performance Check and Proficiency Testing targeted for improvement • An As-Is flow chart of the Performance Check and Pr ...

Suppose in your company you formulate a python script that

Suppose in your company you formulate a Python script that inserts, updates, and deletes data in tables in a MySQL database. You post your Python script on a shared drive for other staff members to use. What are some the ...

Question bull what is the significance of the concept of

Question : • What is the significance of the concept of inheritance within the concept of object oriented programming? How does the concept of inheritance improve on the traditional programming model? • Provide a program ...

Your solution will entail writing a function called

Your solution will entail writing a function called TimeDifference and a test main that demonstrates that you can compute the time difference in minutes between the two times. TimeDifference is a function that receives a ...

Give a recursive algorithm that generates a similar series

Give a recursive algorithm that generates a similar series of coins for changing n cents. Don't use dynamic programming for this problem.

The question is asking how to do it in linuxa scientist ran

The question is asking how to do it in Linux. A scientist ran an experiment that generated data that accumulated in a sequence of files: data1, data2, data3, data4 and data5. He wants to know how many lines of data he ha ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert