Singer

idName
1John Hurt
2Robert Johnson
3Muddy Waters
4Bessie Smith
5Bill Monroe

Blues_Song

idSong_NameGenreSinger_id
(→ Singer.id)
1I Got A Mind To Give Up The BluesBlues1
2Cross Road BluesBlues3
3Hoochie Coochie ManBlues2
4St. Louis BluesBlues4
5Broken Hearted BluesBlues1

Folk_Song

idSong_NameGenreSinger_id
(→ Singer.id)
1Man Of Constant SorrowFolk1
2Tom DooleyFolk3
3The House CarpenterFolk5
4Cripple Creek FerryFolk4
5Pretty PollyFolk2

Album

idTitleYearSinger_id
(→ Singer.id)
1Avalon Blues19671
2Biograph19802
3Electric Mud19683
4The Complete Studio Recordings19914
5Bluegrass19695

Instrument

idType
1Guitar
2Piano
3Drums
4Violin
5Harmonica

Band_Member

idNameInstrument_id
(→ Instrument.id)
1Eddie Boyd1
2Big Bill Broonzy2
3Sunnyland Slim3
4Memphis Minnie4
5Jimmy Rogers5