The following table utilizes organizes tracks by genre, mood, and even activity. Much like Pandora’s Music Genome Project, these associations were added manually and can aid in creating playlists on-the-fly, depending on a specific context.
The following form allows users to enter song requests and add their own associations to become part of the living database and expand upon existing groupings. Automatically creating a new ID, helps ensure that each track maintains its own identity and displays properly within the database.
Additionally, the search function moves across all fields, allowing song results to be clicked into in order to display additional song details and a clickable link to the music video on YouTube. While I could not get duplicate information to consolidate, which is one of the objectives of operating within a relational database, the additional fields allow this information to make some interesting connections across very diverse sets of data.