The structure seems OK, it's just the naming conventions that I would alter. I would go for:

• Albums
• id (pk)
• name

• Artists
• id (pk)
• name (maybe even make this column unique, too)

• Songs
• id (pk)
• album_id (fk)
• artist_id (fk)
• name
• lyrics (consider using full-text search)

You'd set-up 2 relationships: songs.album_id => albums.id and songs.artist_id => albums.id.

Hope this helps!

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.