The table that you made in Part 2 is awesome!

But we can actually make it one step better.

This next part will focus on improving the last two items below:

There’s a lot of information in this table.

We’re going to turn each “idea” into a table of its own.

Then, we can join those tables together using relationships between them.

Remember the Bubble Breakdown you did?

Each of those bubbles because its own table in a well-organized database.

Follow the steps below to split up this big table into three smaller ones for song, album, and artist.

Open me for Video Instructions:

⁠

⁠

⁠

Click the drop-down by Album and turn it into a relation.

Column Type > Relation > Create new table

This should create a new table called "Album" below, with your album names already loaded.

Notice how your album names in the Song table are now bubbles rather than text.

In the new Album table, create new columns for the attributes that should below to the album rather than the song. This should be: Album Cover, Release Date

Make sure to use the appropriate data types.

You can delete the Album Cover and Release Date columns from the Song table now.

Re-add the Album Cover and Release Date columns

Add related column > Album Cover > Value

Repeat steps 1-3 for the Artist. Turn it into its own table, and then remake the attributes. Then delete the old column, and connect the data together.

Awesome! You should now have your old table remade with the connections.

Try changing any information in the Album or Artist tables. Notice how everything changes together!

⁠

⁠

​How to turn Album into a new table

⁠

⁠

⁠

How to remake the Album Cover column with a relationship