The dataset provided for you to perform the requested analysis includes the movement and communication data captured
Question:
The dataset provided for you to perform the requested analysis includes the movement and communication data captured from the park attendees' apps during one weekend (Friday, Saturday, and Sunday).
The database provided by the park administration is formatted to be readable by any SQL database library. The recommended is sqlite3 library. The database contains three tables, named checkin, attraction, and sequences. The database file is named 'dinofunworld.db'.
The information contained in each of these tables is listed below:
checkin: - The check-in data for all visitors for the day in the park. The data includes two types of check-ins: inferred and actual checkins.
- Fields: visitorID, timestamp, attraction, duration, type
attraction: - The attractions in the park by their corresponding AttractionID, Name, Region, Category, and type. Regions are from the VAST Challenge map such as Coaster Alley, Tundra Land, etc. Categories include Thrill rides, Kiddie Rides, etc. Type is broken into Outdoor Coaster, Other Ride, Carousel, etc.
- Fields: AttractionID, Name, Region, Category, type
sequences: - The check-in sequences of visitors. These sequences list the position of each visitor to the park every five minutes. If the visitor has not entered the part yet, the sequence has a value of 0 for that time interval. If the visitor is in the park, the sequence lists the attraction they have most recently checked in to until they check in to a new one or leave the park.
- Fields: visitorID, sequence
The question is as below:
Question 1: What ride (note that not all attractions are rides) has the second longest average visit time?
Managerial Accounting
ISBN: 978-1337270595
14th edition
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac