Genres

genre_idname
1Jazz
2Rock

Artists

idnamemusic_performeryears_in_industry
(→ Genres.name)(→ Artist_genre.years_in_industry)
1John DoeJazz Musician10
2Jane SmithJazz Musician20
3Tom BrownRock Guitarist10
4Emily DavisRock Guitarist30

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