Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Page 3 of 10 Problem 6 (16 points) The Vancouver Mobil Bike spreadsheet has a number of anomalies. Circle the evidence in the spreadsheet data

image text in transcribed
Page 3 of 10 Problem 6 (16 points) The Vancouver Mobil Bike spreadsheet has a number of anomalies. Circle the evidence in the spreadsheet data for each type affected variable(s) with the corresponding letter, and explain why on the lines below. Only one example per anomaly required deletion anomaly marked "D". insertion anomaly marked "r". update anomaly marked "U". multivalued anomaly marked "M". 1102 1819 24 Hour 24 Hou 90 Day Departure Return 11/16/2018 9.00 TRADAR Cover Return station 11/16/2018 9:00 ID00232 1079 0036 Bute & Robson 013 Richards & Helmeken 365 Corporate Standard 8/16/2018 16:00 9/16/2018 16:001007210 1455 1261472 370 661 0155 Arbutus & McNicoll 0077 Vanier Park 10457 /16/2018 16:00 8/16/2018 16:00 17210 661 0077 Vanier Park 0083 Aquatic Centre 7/31/2018 17.00 7/31/2018 17.00 ID00420 00064 Expo & Smith 0154 K ilano Beach Park 24 Hour 6/24/2018 10:00 6/24/2018 10:00 ID00067 30123 Georgia & Thurlow 0123 Georgia & Thurlow 365 Day Founding 1/1/2018 21:00 1/3/2018 21:00 ID00192 1146 0005 Dunsmuir & Beatly 0005 Dunsmuir & Beatly 365 Day Founding Stand 10/31/2017 0:00 10/31/2017 0.00 ID00006454 OSO Rute & Comox 0032 Como & Denman 365 Standard 9 10/29/2017 2300 10/29/2017 23:00 ID00006 35 000 Bute & Comox 0032 Como & Denman 108/24/2017 23:00 24/2017 23:00 N/A 1079 0093 Chico & Robson 0041 Cardero & Robson 24 Hour 101 2017 20:00 1/26/2017 20:00 20001 1478 0048 Comox & Broughton 0001 Morton & Denman 365 Day Founding Plus 971 365 Plus 12 4/27/2017 15:00 4/27/2017 15.00 10000 0028 Davie & Beach 125 0187 Bute & Davie VIP 13 4/21/2017 15.00 4/27/2017 16:00 1001595 0001 10th & Cambie 611 0001 10th & Cambie Archived Monthly Plus 14 1093 0005 Dunsmuir & Beatty 12/2017 22:00 1/26/2017 22.00 10000 Archived Founding Plus 15 11/2017 2 Barclay 0 2/1/2017000 1000103 315 0048 Comox & Broughton 02 Chilco 162 /2017 1700 1/25/2017 17:00 06: 36 193 0001 10th & Camble 0001 10th & Cambio Archived Monthly Stand

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Persuasive Speaking Organizing Patterns in Persuasive Speaking?

Answered: 1 week ago