## Music_Genre

id | Genre
--- | ---
1 | Blues
2 | Rock
3 | Pop
4 | Jazz
5 | Country

## Singers

id | SingerName
--- | ---
1 | John Hurt
2 | Eric Clapton
3 | Bob Dylan
4 | Adele
5 | Elvis Presley

## Albums

id | AlbumTitle | ReleaseYear | Music_Genre_id
--- | --- | --- | ---
|  |  | (→ Music_Genre.id)
1 | The Blues Collection | 2001 | 1
2 | Layla and Other Assorted Love Songs | 1970 | 1
3 | Blood on the Tracks | 1975 | 3
4 | 21 | 2011 | 4
5 | From Elvis Presley Boulevard, Memphis, Tennessee | 1956 | 5

## Songs

id | SongTitle | Duration | Music | Singer_id | Album_id
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Singers.id) | (→ Albums.id)
1 | Blues Song | 300 | Blues Music | 1 | 1
2 | Another Blues Song | 280 | Blues Music | 2 | 1
3 | Folk Song | 290 | Folk Music | 1 | 2
4 | Yet Another Folk Song | 270 | Folk Music | 3 | 2
5 | Love Story | 220 | Pop Music | 4 | 3

## Performances

id | PerformanceDate | Venue | Song_id
--- | --- | --- | ---
|  |  | (→ Songs.id)
1 | 2021-08-15 20:00:00 | Madison Square Garden | 1
2 | 2021-08-16 20:00:00 | Wembley Stadium | 2
3 | 2021-08-17 20:00:00 | Staples Center | 3
4 | 2021-08-18 20:00:00 | O2 Arena | 4
5 | 2021-08-19 20:00:00 | Barclays Center | 5