Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
Page 1 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, mante 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". DAR 1045715 6720 30 Day 24 Hour 1 Departure Cover 2 11/16/2018 9.00 11/16/2018 900 000232 1079 006 Bute & Robson 1455 370 01. Richards & Helmcken 365 Corporate Standard 3 B/16/2018 16:00 9/16/2018 1600 DO 710 661 0155 Arbutus & McNicoll 1/16/2018 16:00 0077 Vanier Park /16/2018 16:00 ID07210 661 0077 Vanier Part 0083 Aquatl Centre 24 Hour 7/31/2018 17:00 7/31/2018 17.00 ID00420 00064 Expo & Smithe 0154 silano Beach Park 24 H 2 018 10.00 ID00007 3 0123 Georgia & Thurlow 0123 Georgia & Thurlow 165 Day Founding Plus 7 1/3/2018 21:00 1/3/2018 21:00 ID00192 1145 0005 Dunsmu & Beatty DOOS Dunsmuir & Beauty 365 Day Founding Stand 8 10/31/20170-00 10/31/2017000 1000006454 OSO Hute & Como 0032 Comos & Denman 365 Standard 9 10/29/2017 2300 10/29/2017 23.0000006 85 0050 Bute & Comox 0032 Como & Derman 108/20/2017 23:00 8/24/2017 23:00 N/A 1079 0093 Chilco & Robson 0041 Cardero & Robson 1 os Day Founding Plus 2 6/2017 20:00 1/26/2017 20:00 1000001 1478048 Comox & Broughton 0011 Morton & Denman 365 Plus 12 4/27/2017 15.00 427/2017 15.00 100000 0028 Davie & Beach 125 0187 Bute & Davie 13 4/27/2017 1500 V27/2017 16.00 001595 641 0001 10th & Cambie 0001 10th & Cambio 1093 0005 Dunsmuir & Beatty 14426/2017 22:00 4/28/2017 22.00 DO 1070 0196 Drake & Hornby Archived Founding Plus 15131/20172300 2/1/2017 0:00 DOOR3315 048 Comox & Broughton 009 Chilco s Barclay 16 1/ 2 017 17:00 1/25/2017 12 06.146193 OO 10th & Cambie 0001 10th & Cambie VIP Archived Monthly Plus 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

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Which is better, controlled access or contention? Explain.

Answered: 1 week ago