## Singer

id | Name
--- | ---
1 | John Hurt
2 | Robert Johnson
3 | Muddy Waters
4 | Bessie Smith
5 | Bill Monroe

## Blues_Song

id | Song_Name | Genre | Singer_id
--- | --- | --- | ---
|  |  | (→ Singer.id)
1 | I Got A Mind To Give Up The Blues | Blues | 1
2 | Cross Road Blues | Blues | 3
3 | Hoochie Coochie Man | Blues | 2
4 | St. Louis Blues | Blues | 4
5 | Broken Hearted Blues | Blues | 1

## Folk_Song

id | Song_Name | Genre | Singer_id
--- | --- | --- | ---
|  |  | (→ Singer.id)
1 | Man Of Constant Sorrow | Folk | 1
2 | Tom Dooley | Folk | 3
3 | The House Carpenter | Folk | 5
4 | Cripple Creek Ferry | Folk | 4
5 | Pretty Polly | Folk | 2

## Album

id | Title | Year | Singer_id
--- | --- | --- | ---
|  |  | (→ Singer.id)
1 | Avalon Blues | 1967 | 1
2 | Biograph | 1980 | 2
3 | Electric Mud | 1968 | 3
4 | The Complete Studio Recordings | 1991 | 4
5 | Bluegrass | 1969 | 5

## Instrument

id | Type
--- | ---
1 | Guitar
2 | Piano
3 | Drums
4 | Violin
5 | Harmonica

## Band_Member

id | Name | Instrument_id
--- | --- | ---
|  | (→ Instrument.id)
1 | Eddie Boyd | 1
2 | Big Bill Broonzy | 2
3 | Sunnyland Slim | 3
4 | Memphis Minnie | 4
5 | Jimmy Rogers | 5