Suppose you are given the James River Jewelry database design as follows:

CUSTOMER $($ CustomerID, LastName, FirstName, Phone, Email$)$

PURCHASE $($ InvoiceNumber, Date, PreTaxAmount, CustomerID$)$

PURCHASE$\_$ITEM $($ InvoiceNumber $,$ ItemNumber, RetailPrice$)$

ITEM $($ ItemNumber, Description, Cost, ArtistName$)$

OWNER $($ OwnerID, Name, Phone, Email, AmountOwed$)$

JEWELRY$\_$ITEM $($ I temNumber, DateReceived, DateSold, NegotiatedSalesPrice, ActualSalesPrice, CommissionPercentage, OwnerID$)$

where

CustomerID in PURCHASE must exist in CustomerID in CUSTOMER

InvoiceNumber in PURCHASE$\_$ITEM must exist in InvoiceNumber in PURCHASE

ItemNumber in PURCHASE$\_$ITEM must exist in ItemNumber in ITEM

OwnerID in JEWELRY$\_$ITEM must exist in OwnerID in OWNER

ItemNumber in JEWELRY$\_$ITEM must exist in ItemNumber in ITEM