# orginal First Normal Form table
mysql: select artist,album,title,year 
       from songs 
    order by artist,year,album,title 
    limit 2;
+----------------+-------------+-----------------+------+
| artist         | album       | title           | year |
+----------------+-------------+-----------------+------+
| 10,000 Maniacs | In My Tribe | A Campfire Song | 1987 |
| 10,000 Maniacs | In My Tribe | Cherry Tree     | 1987 |
+----------------+-------------+-----------------+------+
2 rows in set (0.02 sec)

# new Second Normal Form tables
mysql: select artist.name, album.title as album,
              song.title, album.year
       from artist
       inner join album on artist.id=album.artist_id
       inner join song on album.id=song.album_id
       order by artist.name,album.year,album.title,song.title 
       limit 2;
+----------------+-------------+-----------------+------+
| name           | album       | title           | year |
+----------------+-------------+-----------------+------+
| 10,000 Maniacs | In My Tribe | A Campfire Song | 1987 |
| 10,000 Maniacs | In My Tribe | Cherry Tree     | 1987 |
+----------------+-------------+-----------------+------+
2 rows in set (0.04 sec)