Given the following dataset for acoustic detections of Gray whales in the Pacific ocean: date latitude longitude tracked

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Given the following dataset for acoustic detections of Gray whales in the Pacific ocean: date latitude longitude tracked

Post by answerhappygod »

Given The Following Dataset For Acoustic Detections Of Gray Whales In The Pacific Ocean Date Latitude Longitude Tracked 1
Given The Following Dataset For Acoustic Detections Of Gray Whales In The Pacific Ocean Date Latitude Longitude Tracked 1 (77.78 KiB) Viewed 28 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply