Have a look at our related tables:

Unlike primary keys, a table can have multiple foreign keys, and foreign keys can be empty fields.

Two songs in our playlist belong to the same album. SQL is pretty cool, huh?