| id | Genre |
|---|---|
| 1 | Blues |
| 2 | Rock |
| 3 | Pop |
| 4 | Jazz |
| 5 | Country |
| id | SingerName |
|---|---|
| 1 | John Hurt |
| 2 | Eric Clapton |
| 3 | Bob Dylan |
| 4 | Adele |
| 5 | Elvis Presley |
| 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 |
| id | SongTitle | Duration | Music | Singer_id | Album_id |
|---|---|---|---|---|---|
| (→ Singers.id) | (→ Albums.id) | ||||
| 1 | Blues Song | 300 | 186e16">Blues Music | 1 | 1 |
| 2 | Another Blues Song | 280 | 186e16">Blues Music | 2 | 1 |
| 3 | Folk Song | 290 | 186e16">Folk Music | 1 | 2 |
| 4 | Yet Another Folk Song | 270 | Folk Music | 3 | 2 |
| 5 | Love Story | 220 | Pop Music | 4 | 3 |
| 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 |