MySQL Database: Taylor Swift

Project Overview & Core Objective:

The primary purpose of this project was to create a database detailing and breaking apart a subject we cared about, so I set out to create a database that housed Taylor Swift’s discography using MySQL.

Procedures & Results:

1

Determine subject and break it up into attributes

Subject:

Taylor Swift’s Discography

Listed to the right are the:

Subject Attributes: What makes up these songs

The corresponding MySQL Data Types used for each category

  • Song Title - tinytext

  • Album - tinytext

  • Song Type - tinytext

  • Musical Key - tinytext

  • Beats Per Minute (BPM) - int

  • Record Label - tinytext

  • Release Year - year

  • Song Length - time

  • Energy - tinytext

  • Streams - int

2

Create database structure

The database structure served as instruction to how everything was to be connected in the actual database itself. This is where I determined that different ID’s that would be used for each category as well to have everything more organized.

3

Input data into excel and use sublime to create codes

The images to the right are a small demonstration of the repeated codes I used and the information on Excel that was ultimately placed in the database.

4

Through simplified insert queries input data into MySQL

I laid out my database insert queries on Sublime and then input them into the MySQL database once I was sure everything was accurate.

5

Test the database by breaking up and compiling data with codes.

In the image to the right, I used a SELECT & INNER JOIN commands to put together her songs along with their corresponding album and organizing the table by album release year.

The bottom two images showcase other similar commands and their respective results.

In this final step I used simple MySQL commands to find specific data quicker, as well as joining specific sets of data together. Overall ensuring worked properly.

Concluding Thoughts

Using MySQL basics I was able to create an efficient and culminating database that housed Taylor Swift’s music through various categories. The overall goal of making it as clear and concise as possible was achieved, as well as making a categorical system that was based on the technical aspects of songs.