Marcia Wilson owns and operates Marcia’s Dry Cleaning, which is an upscale dry cleaner in a well-to-do suburban neighborhood. Marcia makes her business stand out from the competition by providing...

Marcia Wilson owns and operates Marcia’s Dry Cleaning, which is an upscale dry cleaner in a well-to-do suburban neighborhood. Marcia makes her business stand out from the competition by providing superior customer service. She wants to keep track of each of her customers and their orders. Ultimately, she wants to notify them that their clothes are ready via e-mail. To provide this service, she has developed an initial database with several tables. Three of those tables are the following:

 CUSTOMER (Customer ID, First Name, Last Name, Phone, Email) INVOICE (Invoice Number, Customer Number, Date In, Date Out, Total Amount) INVOICE_ITEM (Invoice Number, Item Number, Item, Quantity, Unit Price)