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)
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.
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F788dab94-01ba-414a-9745-8d14d9dc9223%2F994188d7-ce23-49c9-bd0e-7331db9fa6a8%2F237msm_processed.png&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY