A B F H AmountCharged 1 Transaction No. Date G Fragrance Coconut Included Services 2 $150 Presoak, Wax, Rain Protection, Tyre Shine, Wheel Clean, Underbody Wash Wheel Clean, Underbody Wash Pine $80 Rain Protection, Tyre Shine, Wheel Clean, Underbody Wash Morning Fresh $120 D FirstName LastName PackagePurchased 2011212 14/05/2019 Michael Schumacher The Royal Touch Senna Deluxe Wash Schumacher Ultimate Wash Bourne The Royal Touch Schumacher Deluxe Wash Senna Ultimate Wash Bourne Express Wash Schumacher Express Wash 2011213 14/05/2019 Ayrton 2011214 14/05/2019 Ralph 2011215 16/05/2019 Peter 2011216 16/05/2019 Ralph 2011217 17/05/2019 Ayrton 2011218 17/05/2019 Peter 2011219 17/05/2019 Michael $150 Presoak, Wax, Rain Protection, Tyre Shine, Wheel Clean, Underbody Wash Black Ice Wheel Clean, Underbody Wash $80 Morning Fresh Pine $120 Rain Protection, Tyre Shine, Wheel Clean, Underbody Wash Soft Cloth Wash Black Ice $50 9 Soft Cloth Wash Coconut $50 During the period between 14th and 17th of May in 2019, business transactions with several premium customers have taken place. They are recorded in the spreadsheet above. Zoom in with Ctrl+ to see a clearer picture. Question 5 Assuming that all entries are correct, describe ONE issue of Data Redundancy and ONE potential issue with Data Consistency if a large amount of such data is recorded in a spreadsheet document. Copy the following answer template and paste it into the answer area. Use this template to format your response. Issue with Data Redundancy: Potential issue with Data Consistency: 3 4 5 6 7 8
A B F H AmountCharged 1 Transaction No. Date G Fragrance Coconut Included Services 2 $150 Presoak, Wax, Rain Protection, Tyre Shine, Wheel Clean, Underbody Wash Wheel Clean, Underbody Wash Pine $80 Rain Protection, Tyre Shine, Wheel Clean, Underbody Wash Morning Fresh $120 D FirstName LastName PackagePurchased 2011212 14/05/2019 Michael Schumacher The Royal Touch Senna Deluxe Wash Schumacher Ultimate Wash Bourne The Royal Touch Schumacher Deluxe Wash Senna Ultimate Wash Bourne Express Wash Schumacher Express Wash 2011213 14/05/2019 Ayrton 2011214 14/05/2019 Ralph 2011215 16/05/2019 Peter 2011216 16/05/2019 Ralph 2011217 17/05/2019 Ayrton 2011218 17/05/2019 Peter 2011219 17/05/2019 Michael $150 Presoak, Wax, Rain Protection, Tyre Shine, Wheel Clean, Underbody Wash Black Ice Wheel Clean, Underbody Wash $80 Morning Fresh Pine $120 Rain Protection, Tyre Shine, Wheel Clean, Underbody Wash Soft Cloth Wash Black Ice $50 9 Soft Cloth Wash Coconut $50 During the period between 14th and 17th of May in 2019, business transactions with several premium customers have taken place. They are recorded in the spreadsheet above. Zoom in with Ctrl+ to see a clearer picture. Question 5 Assuming that all entries are correct, describe ONE issue of Data Redundancy and ONE potential issue with Data Consistency if a large amount of such data is recorded in a spreadsheet document. Copy the following answer template and paste it into the answer area. Use this template to format your response. Issue with Data Redundancy: Potential issue with Data Consistency: 3 4 5 6 7 8
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
Transcribed Image Text:A
B
с
E
F
H
1 Transaction No. Date
Included Services
G
Fragrance
Coconut
AmountCharged
2
$150
Presoak, Wax, Rain Protection, Tyre Shine, Wheel Clean, Underbody Wash
Wheel Clean, Underbody Wash
3
$80
4
$120
D
FirstName LastName PackagePurchased
2011212 14/05/2019 Michael Schumacher The Royal Touch
2011213 14/05/2019 Ayrton Senna
Deluxe Wash
2011214 14/05/2019 Ralph Schumacher Ultimate Wash
2011215 16/05/2019 Peter Bourne The Royal Touch
2011216 16/05/2019 Ralph Schumacher Deluxe Wash
2011217 17/05/2019 Ayrton Senna
Ultimate Wash
2011218 17/05/2019 Peter Bourne Express Wash
2011219 17/05/2019 Michael Schumacher Express Wash
5
Rain Protection, Tyre Shine, Wheel Clean, Underbody Wash
Presoak, Wax, Rain Protection, Tyre Shine, Wheel Clean, Underbody Wash
Wheel Clean, Underbody Wash
$150
Pine
Morning Fresh
Black Ice
Morning Fresh
Pine
Black Ice
6
$80
7
$120
8
Rain Protection, Tyre Shine, Wheel Clean, Underbody Wash
Soft Cloth Wash
Soft Cloth Wash
$50
9
Coconut
$50
During the period between 14th and 17th of May in 2019, business transactions with several premium customers
have taken place. They are recorded in the spreadsheet above. Zoom in with Ctrl+ to see a clearer picture.
Question 5
Assuming that all entries are correct, describe ONE issue of Data Redundancy and ONE potential issue
with Data Consistency if a large amount of such data is recorded in a spreadsheet document.
Copy the following answer template and paste it into the answer area. Use this template to format your
response.
Issue with Data Redundancy:
Potential issue with Data Consistency:
Fill in your answer here
Expert Solution
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
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
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)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY