Modify what you consider to be the best design to include a column called AwardPurchaseAmount. The purpose of this column is to keep a balance of the customers’ purchases for award purposes. Assume that returns will be recorded with invoices having a negative PreTaxAmount.Add a new AWARD table to your answer to part 1. Assume that the new table will hold data concerning the date and amount of an award that is given after a customer has purchased 10 items. Ensure that your new table has appropriate primary and foreign keys. Figure D-1 shows data that James River Jewelry collects for its frequent buyer program. Phone555-236-7789555-236-0091555-236-0392555-236-4493555-236-3334555-236-7789555-236-0392555-236-7789555-236-1095InvoiceNumber1000Pre TaxAmount155.00NameDate5/5/2012EmailElizabeth StanleyElizabeth Stanley@somewhere.comFred.Price@somewhere.comLinda.Becky@somewhere.comPamela.Birch@somewhere.comRichard.Romez@somewhere.comElizabeth Stanley@somewhere.comLinda. Becky@somewhere.comElizabeth. Stanley@somewhere.comSamantha. Jackson@somewhere.comFred Price101010205/7/20125/11/2012203.0075.00Linda BeckyPamela Birch67.00330.0010305/15/2012Richardo RomezElizabeth StanleyLinda BeckyElizabeth StanleySamantha Jackson10405/15/20125/16/20125/16/2012105025.0045.001060107010805/18/20125/19/2012445.0072.00Figure D-1: Sample Data for James River Jewelry

To add an Award Purchase Amount column, data required includes the customer's unique ID, here Email…

Answered: Phone 555-236-7789 555-236-0091…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Modify what you consider to be the best design to include a column called AwardPurchaseAmount. The purpose of this column is to keep a balance of the customers’ purchases for award purposes. Assume that returns will be recorded with invoices having a negative PreTaxAmount.
Add a new AWARD table to your answer to part 1. Assume that the new table will hold data concerning the date and amount of an award that is given after a customer has purchased 10 items. Ensure that your new table has appropriate primary and foreign keys.

Figure D-1 shows data that James River Jewelry collects for its frequent buyer program.