User Account

All Pages

Find average number of books borrowed from database table

Assignment Help Database Management System
Reference no: EM1364797

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

Questions Cloud

How to assume the protons started from very far away : how to Assume the protons started from very far away. Need X and Y componet.
All about quantitative reasoning for business : What are two examples of how simultaneous equations are used in business? What are some of the different ways you can satisfy these equations?
Describe how each component of your model lends : Describe how each component of your model lends itself to optimal employee performance and Develop a coaching model that optimizes performance management activities.
Depreciation and book value of investment : Determine the depreciation and book value for each of the two investment groups for each year. Determine the gain/loss for tax purposes If the Group 5 and Group 7 assets are sold at the end of the planning period for a combined $500,000.
Find average number of books borrowed from database table : 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.
Weaknesses are defined as constraints : Weaknesses are defined as constraints - How does below theory apply to your current or most recent employer?
Exchanging dollars for euro : If I plan to go to Germany thirty days and the spot exchange rate is $1.30=1 euro. The thirty day forward rate is $1.36=1 euro.
Government in health care policy formulation : Describe the relationship between the state and the federal government in health care policy formulation and implementation.
What is the distance of closest approach of the two particle : what is the distance of closest approach of the two particles. explain two ways in which you could you this equipment to raise the crate.

Reviews

Write a Review

Database Management System Questions & Answers

  Create library database schema structure

The library System stores 3 type of informations: Users ( USID, USNAME, USMob, USEmail, USDept,USStartDate, NofBooks). Create the library database schema Structure.

  Database system development

The database application project (DAP) for this course consists of the creation of a fully functional Microsoft Access database application for a real client.

  Prepare a set of non-functional requirements

Need a system that networks its 3 campuses in the US and one campus in Singapore. Transaction data for all campuses should be available to all locations. In addition, students should be able to use the Internet to view classes, enroll, register, and ..

  Create a database from scratch

Create a database from scratch that contains, at a minimum, the elements listed below

  Executing well-planned strategy-manage technology solution

You have a company, specializing in managing technology solutions. you have ben just hired by big firm to execute a well-planned strategy.

  Define a data flow in bus information system

Name four attributes that you can use to define a data flow in the bus information system. Name four attributes that you can use to define a data store in the bus information system.

  Design updateable database for storing customer and sales

Design an updateable database for storing customer and sales data. Explain how to deal with the problems of missing data.

  Study and modify the postgresql source code

Write a Assignment to study and modify the PostgreSQL source code, with a focus on one of the core modules - the buffer manager

  Yrace history of the development of databases

In 500 words or less, trace the history of the development of databases beginning with pre-computer days to the present.

  Create a report which identifies five most expensive bicycle

Create a report which identifies five most expensive bicycles. The report must list bicycles in descending order from most expensive to lease expensive, the quantity on hand for each, and the markup percentage for each.

  Determine cost of least expensive part in part table

Write a query to determine the cost of the least expensive part in the part table? Format the returned price in dollars and cents using the correct function.

  Explaining emp table does not have assigned primary key

Developers have noticed that EMP table doesn't have an assigned primary key. EMP_ID column has been selected to be the primary key.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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