Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Phone 555-236-7789 555-236-0091 555-236-0392 555-236-4493 555-236-3334 555-236-7789 555-236-0392 555-236-7789 555-236-1095 InvoiceNumber 1000 Pre TaxAmount 155.00 Name Date 5/5/2012 Email Elizabeth Stanley Elizabeth Stanley@somewhere.com Fred.Price@somewhere.com Linda.Becky@somewhere.com Pamela.Birch@somewhere.com Richard.Romez@somewhere.com Elizabeth Stanley@somewhere.com Linda. Becky@somewhere.com Elizabeth. Stanley@somewhere.com Samantha. Jackson@somewhere.com Fred Price 1010 1020 5/7/2012 5/11/2012 203.00 75.00 Linda Becky Pamela Birch 67.00 330.00 1030 5/15/2012 Richardo Romez Elizabeth Stanley Linda Becky Elizabeth Stanley Samantha Jackson 1040 5/15/2012 5/16/2012 5/16/2012 1050 25.00 45.00 1060 1070 1080 5/18/2012 5/19/2012 445.00 72.00 Figure D-1: Sample Data for James River Jewelry

Phone 555-236-7789 555-236-0091 555-236-0392 555-236-4493 555-236-3334 555-236-7789 555-236-0392 555-236-7789 555-236-1095 InvoiceNumber 1000 Pre TaxAmount 155.00 Name Date 5/5/2012 Email Elizabeth Stanley Elizabeth Stanley@somewhere.com Fred.Price@somewhere.com Linda.Becky@somewhere.com Pamela.Birch@somewhere.com Richard.Romez@somewhere.com Elizabeth Stanley@somewhere.com Linda. Becky@somewhere.com Elizabeth. Stanley@somewhere.com Samantha. Jackson@somewhere.com Fred Price 1010 1020 5/7/2012 5/11/2012 203.00 75.00 Linda Becky Pamela Birch 67.00 330.00 1030 5/15/2012 Richardo Romez Elizabeth Stanley Linda Becky Elizabeth Stanley Samantha Jackson 1040 5/15/2012 5/16/2012 5/16/2012 1050 25.00 45.00 1060 1070 1080 5/18/2012 5/19/2012 445.00 72.00 Figure D-1: Sample Data for James River Jewelry

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
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...
See similar textbooks
icon
Related questions
Question
  1. 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.
  2. 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.

 

 

Phone 555-236-7789 555-236-0091 555-236-0392 555-236-4493 555-236-3334 555-236-7789 555-236-0392 555-236-7789 555-236-1095 InvoiceNumber 1000 Pre TaxAmount 155.00 Name Date 5/5/2012 Email Elizabeth Stanley Elizabeth Stanley@somewhere.com Fred.Price@somewhere.com Linda.Becky@somewhere.com Pamela.Birch@somewhere.com Richard.Romez@somewhere.com Elizabeth Stanley@somewhere.com Linda. Becky@somewhere.com Elizabeth. Stanley@somewhere.com Samantha. Jackson@somewhere.com Fred Price 1010 1020 5/7/2012 5/11/2012 203.00 75.00 Linda Becky Pamela Birch 67.00 330.00 1030 5/15/2012 Richardo Romez Elizabeth Stanley Linda Becky Elizabeth Stanley Samantha Jackson 1040 5/15/2012 5/16/2012 5/16/2012 1050 25.00 45.00 1060 1070 1080 5/18/2012 5/19/2012 445.00 72.00 Figure D-1: Sample Data for James River Jewelry
Transcribed Image Text:Phone 555-236-7789 555-236-0091 555-236-0392 555-236-4493 555-236-3334 555-236-7789 555-236-0392 555-236-7789 555-236-1095 InvoiceNumber 1000 Pre TaxAmount 155.00 Name Date 5/5/2012 Email Elizabeth Stanley Elizabeth Stanley@somewhere.com Fred.Price@somewhere.com Linda.Becky@somewhere.com Pamela.Birch@somewhere.com Richard.Romez@somewhere.com Elizabeth Stanley@somewhere.com Linda. Becky@somewhere.com Elizabeth. Stanley@somewhere.com Samantha. Jackson@somewhere.com Fred Price 1010 1020 5/7/2012 5/11/2012 203.00 75.00 Linda Becky Pamela Birch 67.00 330.00 1030 5/15/2012 Richardo Romez Elizabeth Stanley Linda Becky Elizabeth Stanley Samantha Jackson 1040 5/15/2012 5/16/2012 5/16/2012 1050 25.00 45.00 1060 1070 1080 5/18/2012 5/19/2012 445.00 72.00 Figure D-1: Sample Data for James River Jewelry
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS