As far as structure goes, I want to have a list of songs in Genre's on my website.
Lets call my database Songs
and a table for each genre (Techno, House, Progressive)
The structure for each table is:
ID, Artist, Song, Mix
Is that an Ok way of doing it instead of having one table structured like this:
ID, Artist, Song, Mix, Genre
If not, what are the downfalls?