Page 1 of 1
Given the following dataset for acoustic detections of Gray whales in the Pacific ocean: date latitude longitude tracked
Posted: Mon Jun 06, 2022 5:47 pm
by answerhappygod
- Given The Following Dataset For Acoustic Detections Of Gray Whales In The Pacific Ocean Date Latitude Longitude Tracked 1 (77.78 KiB) Viewed 30 times
Given the following dataset for acoustic detections of Gray whales in the Pacific ocean: date latitude longitude tracked depth range duration 2020/01/24 -22.142 113.728 1 20 S 10 2020/01/31 -22.277 113.823 1 34 S 20 2020/02/06 -22.3 113.757 1 18 SW 17 2020/02/20 -22.21 112.707 0 10 N 11 2020/02/27 -22.319 113.804 22 S -5 2020/03/01 -21.128 115.137 |1 67 SW 23 2020/03/17 -20.14 115.704 1 NE 16 2020/03/22 -15.314 123.166 1 19 E 8 The whales are detected by monitoring the acoustic signals from hydrophones (under-water microphones) at different sensor stations in the Pacific. date is the timestamp of the detection; latitude and longitude is the GPS location of the hydrophone in decimal degrees; tracked is 1 if this detection event is part of a track, otherwise 0; depth is the water depth in meters; range is the direction to the detected whale; duration is the duration of the event in seconds. Assume that you get this data as a tab-delimited CSV file. Name at least three problems when trying to import this dataset into a relational database and briefly explain how you would solve each of these problems.