I'm creating a lyrics script (as I have posted in another thread), and I was thinking today that my previous database structure wasn't great at all. I rethought it, and think that this new way might be a bit better, but I want to see what you guys think before I go with it.
I have 3 tables, albums, artists, and songs, which could all easily be used together (by JOIN's I believe?), to get the information where it's needed.
So is there any improvements I could make? The reason why I thought separate tables would be better, is to make it easier to make "Browse" pages on the site, and it still wouldn't take away much from getting all the info for a lyrics page.