Marcia wants to keep track of each of her customers and their
orders. Ultimately, she wants to notify them that their clothes are
ready via email. Suppose that you have designed a database for
Marcia’s Dry Cleaning that has the following tables:
CUSTOMER (CustomerID, FirstName, LastName, Phone,
EmailAddress)
INVOICE (InvoiceNumber, CustomerID, DateIn, DateOut, Subtotal,
Tax, TotalAmount)
INVOICE_ITEM (InvoiceNumber, ItemNumber, ServiceID, Quantity,
UnitPrice, ExtendedPrice)
SERVICE (ServiceID, ServiceDescription, UnitPrice)
The referential integrity constraints are:
CustomerID in INVOICE must exist in CustomerID in...