Page 3 10 Problem 6 16 Points Vancouver Mobi Bike Spreadsheet Number Anomalies Circle Evid Q43792431
Page 3 of 10 Problem 6 (16 points) The Vancouver Mobi Bike spreadsheet has a number of anomalies Circle the evidence in the spreadsheet data for each type of anomaly, mark the 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”. Return station TRODAS 370 1261472 104579 1045715 1274 24 Hour 998 Return 65 201354 90 Day 24 Hour 2003 1700 B C D Departure Retum Arco Departure station Formula Cover 11/16/2018 9:00 11/16/2018 9.00 ID00232 1079 00.36 Bute & Robson 0138 Richards & Helmcken 365 Corporate Standard 1455 8/16/2018 16:00 8/16/2018 16:00 ID07210 661 0155 Arbutus & McNicoll 0077 Vanier Park 24 Hour 8/16/2018 16:00 8/16/2018 16:00 ID07210 661 0077 Vanier Park 003 Aquatic Centre 5 7/31/2018 17:00 7/31/2018 17.00 100420 00064 Expo & Smithe 0154 Kitilano Beach Park 24 Hour 4445 6 6/24/2018 10:00 6/24/2018 10:00 ID00067 30123 Georgia & Thurlow 0123 Georgia & Thurlow 365 Day Founding Plus 1/2018 21:00 1/3/2018 21:00 ID00192 1146 0005 Dunsmul & Beatly 0005 Dunsmuir & Beatly 365 Day Founding Stand 10/31/2017 0:00 10/31/2017 0:00 ID00006454 0050 Bute & Comox 0032 Como & Denman 365 Standard 9 10/29/2017 23:00 10/29/2017 23:00 ID00006 385 OSO Bute & Comok 0032 Comox & Denman 10 /24/2017 21.00 8/24/2017 23.00 N/A 1079 0093 Chilco & Robson 0041 Cardero & Robson 11 7/26/2017 20:00 7/26/2017 20:00 ID00001 1478 0018 Comox & Broughton 0031 Morton & Denman 365 Day Founding Plus 365 Plus 12 427/2017 15.00 4/27/2017 15.00 ID00008 0028 Davie & Beach 125 0187 Bute & Davie VIP 13 0001 10th & Cambio 641 0001 10th & Cambie 427/2017 15:00 4/27/2017 16:00 101595 Archived Monthly Plus 1 2 6/2017 22.00 4/26/2017 22:00 0196 Drake & Hornby 0008 1093 0005 Dunsmuir & Beatly Archived Founding Plus 15 3/2017 2100 2/1/2017 0:00 000 048 Comox & Broughton 0092 Chilco & Barclay Archived Monthly Stand 1 0001 10th & Cambio 193.0001 10th & Cambie 1/25/2017 1700 1/25/2017 17.00 ID06346 123 1078 Show transcribed image text Page 3 of 10 Problem 6 (16 points) The Vancouver Mobi Bike spreadsheet has a number of anomalies Circle the evidence in the spreadsheet data for each type of anomaly, mark the 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”. Return station TRODAS 370 1261472 104579 1045715 1274 24 Hour 998 Return 65 201354 90 Day 24 Hour 2003 1700 B C D Departure Retum Arco Departure station Formula Cover 11/16/2018 9:00 11/16/2018 9.00 ID00232 1079 00.36 Bute & Robson 0138 Richards & Helmcken 365 Corporate Standard 1455 8/16/2018 16:00 8/16/2018 16:00 ID07210 661 0155 Arbutus & McNicoll 0077 Vanier Park 24 Hour 8/16/2018 16:00 8/16/2018 16:00 ID07210 661 0077 Vanier Park 003 Aquatic Centre 5 7/31/2018 17:00 7/31/2018 17.00 100420 00064 Expo & Smithe 0154 Kitilano Beach Park 24 Hour 4445 6 6/24/2018 10:00 6/24/2018 10:00 ID00067 30123 Georgia & Thurlow 0123 Georgia & Thurlow 365 Day Founding Plus 1/2018 21:00 1/3/2018 21:00 ID00192 1146 0005 Dunsmul & Beatly 0005 Dunsmuir & Beatly 365 Day Founding Stand 10/31/2017 0:00 10/31/2017 0:00 ID00006454 0050 Bute & Comox 0032 Como & Denman 365 Standard 9 10/29/2017 23:00 10/29/2017 23:00 ID00006 385 OSO Bute & Comok 0032 Comox & Denman 10 /24/2017 21.00 8/24/2017 23.00 N/A 1079 0093 Chilco & Robson 0041 Cardero & Robson 11 7/26/2017 20:00 7/26/2017 20:00 ID00001 1478 0018 Comox & Broughton 0031 Morton & Denman 365 Day Founding Plus 365 Plus 12 427/2017 15.00 4/27/2017 15.00 ID00008 0028 Davie & Beach 125 0187 Bute & Davie VIP 13 0001 10th & Cambio 641 0001 10th & Cambie 427/2017 15:00 4/27/2017 16:00 101595 Archived Monthly Plus 1 2 6/2017 22.00 4/26/2017 22:00 0196 Drake & Hornby 0008 1093 0005 Dunsmuir & Beatly Archived Founding Plus 15 3/2017 2100 2/1/2017 0:00 000 048 Comox & Broughton 0092 Chilco & Barclay Archived Monthly Stand 1 0001 10th & Cambio 193.0001 10th & Cambie 1/25/2017 1700 1/25/2017 17.00 ID06346 123 1078
Expert Answer
Answer to Page 3 of 10 Problem 6 (16 points) The Vancouver Mobi Bike spreadsheet has a number of anomalies Circle the evidence in …
OR