L07: Data Organization
L07: Reflection
For presentations, it’s about making slides, adding text and images, and knowing how to keep things simple so the audience doesn’t get overloaded. Good design matters just as much as good information.
When it comes to databases, it’s about storing large amounts of information in a way that’s easy to find and update. Learning about tables, fields, and queries made me realize how important databases are for keeping businesses organized.
L07: SQL Statements
L07: Music Genome Project
Music Genome Project
The data is collected from every song entered into its database. The data is used to give a “personalized listening experience”.
what artist did you pick and what were the songs?
Seed Artist: Beethoven. Symphony No. 7. Allegretto.
Beethoven. Symphony No. 3. Eroica
Tchaikovsky. Swan lake.
IV. Allegro Con Fuoco
Beethoven. Egmont Overture.
What are the categories/musical style being used to classify the songs that were played?
Music Genre. Artist. Melody. Instruments. Lyrics. Vocal style.
What clues do these categories provide about the database structure being used?
Filter first by the music genre and then match by artist. Then similar classical music.
Do you like songs?
No. I only like the seed song I put in. I’m particular when it comes to classical music so I’m not surprised. I tend to like one or two songs from each artist rather than every song from a particular artist.
Would you put these songs together in a playlist?
No, I won’t.
L07: Cold Case
Cold Case
DNA sampling played a pivotal role in linking Dellando Recardo Campbell to the 2009 murder of Serika Dunkley Holness. ““The blood Dellando Campbell left behind at the 2009 crime scene was analyzed and entered into a national DNA database, where it waited four years for a match,” said U.S. Attorney Rod J. Rosenstein” (U.S. Attorney’s Office, District of Maryland, 2014). This match served as the key evidence in establishing that Campbell as the second participant to the crime. The DNA evidence was collected from two places: at a rural Maryland crime scene where the victim’s items had droplets of blood and in 2013, during an unrelated arrest in Lemoore, California police had collected a DNA sample from Campbell. These two pieces of DNA evidence ultimately linked him to the crime. DNA evidence of people not convicted of a crime should follow strict protocol in how long the DNA sample remains in the database and be properly expunged from the system after a predetermined period.
U.S. Attorney’s Office, District of Maryland. (2014, July 28). California man pleads guilty to Maryland murder solved by DNA [Press release]. U.S. Attorney’s Office, District of Maryland.
