Genres

genre_idname
1Jazz
2Rock

Albums

idtitlerelease_dateartist_id
(→ Artists.id)
1Jazz Collection2022-01-011
2Classical Jazz2022-07-012
3Guitar Masterpieces2022-06-013
4Acoustic Rock2022-08-014

Songs

idtitlelengthalbum_id
(→ Albums.id)
1Cool Blues3.51
2Elegant Waltz4.22
3Fast Riff3.03
4Slow Ballad4.74

Artist_genre

artist_idgenre_idyears_in_industry
(→ Artists.id)(→ Genres.genre_id)
1110
2120
3210
4230

Artists

idname
1John Doe
2Jane Smith
3Tom Brown
4Emily Davis