Musicians

idnamemusician_type
1John DoeCountry Singer
2Jane SmithCountry Singer
3Bob JohnsonBluegrass Singer
4Alice BrownBluegrass Singer
5Tom GreenRock Star
6Emily WhitePop Singer

Instruments

idinstrument_name
1Guitar
2Violin
3Piano
4Drums
5Bass Guitar

Songs

idsong_titlerelease_date
1My Favorite Song2018-07-01
2Another Great Song2019-06-30
3Awesome Tune2020-05-15
4Amazing Melody2021-04-10
5Fantastic Track2022-03-01

Albums

idalbum_titlerelease_yearartist_id
(→ Musicians.id)
1First Album20101
2Second Album20111
3Third Album20122
4Fourth Album20132
5Fifth Album20143

SongAlbum

idsong_idalbum_id
(→ Songs.id)(→ Albums.id)
111
222
333
444
555

MusicianInstrument

idmusician_idinstrument_id
(→ Musicians.id)(→ Instruments.id)
111
212
323
431
544