Figure $8\mathrm{.}14$

A relational database

schema for a LIBRARY

database.

a$.$ List the Order# and Ship$\_$date for all orders shipped from Warehouse# W$2.$

b$.$ List the WAREHOUSE information from which the CUSTOMER

named Jose Lopez was supplied his orders. Produce a listing: Order#$,$

Warehouse#$.$

c$.$ Produce a listing Cname, No$\_$of$\_$orders, Avg$\_$order$\_$amt, where the middle

column is the total number of orders by the customer and the last column

is the average order amount for that customer.

d$.$ List the orders that were not shipped within $30$ days of ordering.

e$.$ List the Order# for orders that were shipped from all warehouses that the

company has in New York.

$8\mathrm{.}20.$ Specify the following queries in relational algebra on the database schema

given in Exercise $5\mathrm{.}15$:

a$.$ Give the details $($all attributes of trip relation$)$ for trips that exceeded

$$2,000$ in expenses.

TO WRITE THE RELATIONAL ALGEBRA FOR THE RELATIONS