Search found 5 matches
- Mon Mar 20, 2017 3:40 pm
- Forum: Winter 2017
- Topic: 4 Student Defined Final Project
- Replies: 10
- Views: 12247
Re: 4 Student Defined Final Project
My goal for this project was looking at interesting ways to create connections within a set of data. I knew from the start, I wanted to do something with music as I have a somewhat familiar relationship with it. I turned towards Spotify – a music streaming/social media platform because it had an int...
- Thu Feb 23, 2017 3:36 am
- Forum: Winter 2017
- Topic: 3D Visualization
- Replies: 10
- Views: 10627
Re: 3D Visualization
I was interested in patterns of how checkout times and dates reflected on checkout durations. For this representative data set, I focused my ideas on three main search terms: cyber, virtual, and digital as I believed this would help to create the overall design of my visualization. digital.png My qu...
- Tue Jan 31, 2017 11:31 am
- Forum: Winter 2017
- Topic: 2D Frequency Pattern Visualization
- Replies: 11
- Views: 10919
Re: 2 2D Frequency Pattern Visualization
My question was how different media types experience variation in popularity over the course of a ten year period. Seeing as how different media formats go out of fashion with the advent of newer platforms, I wanted to track when certain media types experience life, growth, or death. My query: SELEC...
- Thu Jan 19, 2017 4:50 pm
- Forum: Winter 2017
- Topic: 1 Advanced MySQL: Frequency Pattern
- Replies: 10
- Views: 9458
Re: 1b Advanced MySQL: Frequency Pattern
As the number and formats of media change - especially in the last 20 or 30 years, some are eventually phased out while others remain popular. When it comes to this dataset, I wanted to investigate those sorts of changes within a decade in the context of library checkouts, from 2006-2016. Ultimately...
- Thu Jan 12, 2017 12:57 am
- Forum: Winter 2017
- Topic: 1a Basic MySQL
- Replies: 11
- Views: 11338
Re: 1a Basic MySQL
Question 1: How many items about gluten were checked out prior to 2007? SELECT DISTINCT spl_2016.title.title, spl_2016.collectionCode.itemNumber, spl_2016.transactions.checkOut FROM spl_2016.transactions INNER JOIN spl_2016.title ON spl_2016.transactions.bibNumber = spl_2016.title.bibNumber INNER J...