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 | 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 |
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 |