ArtistID | ArtistName |
---|---|
1 | Adele |
2 | Beyonce |
3 | Michael Buble |
4 | Elton John |
5 | Justin Timberlake |
AlbumID | Year | Month | AlbumName | Genre | ArtistID |
---|---|---|---|---|---|
(→ Artists.ArtistID) | |||||
1 | 2019 | 11 | 25 | Pop | 1 |
2 | 2016 | 4 | Lemonade | R&B/Hip Hop | 2 |
3 | 2013 | 11 | To Be Loved | Jazz | 3 |
4 | 2018 | 11 | Captain Fantastic and The Brown Dirt Cowboy | Rock | 4 |
5 | 2007 | 6 | FutureSex/LoveSound | R&B/Pop | 5 |
SongID | SongTitle | Duration | AlbumID |
---|---|---|---|
(→ Albums.AlbumID) | |||
1 | Hello | 306 | 1 |
2 | Formation | 224 | 2 |
3 | Stronger | 214 | 2 |
4 | All of Me | 215 | 3 |
5 | Can You Feel the Love Tonight | 182 | 4 |
LabelID | LabelName | ArtistID |
---|---|---|
(→ Artists.ArtistID) | ||
1 | XL Recordings | 1 |
2 | Parkwood Entertainment | 2 |
3 | Republic Records | 5 |
ConcertID | Date | Venue | City | Country | HeadlinerID | OpeningActID |
---|---|---|---|---|---|---|
(→ Artists.ArtistID) | (→ Artists.ArtistID) | |||||
1 | 2020-12-31 | Madison Square Garden | New York | USA | 1 | None |
2 | 2021-01-15 | Staples Center | Los Angeles | USA | 2 | None |
3 | 2021-02-10 | O2 Arena | London | UK | 3 | None |
4 | 2021-02-20 | Barclays Centre | Brooklyn | USA | 4 | None |
5 | 2021-03-05 | Sydney Opera House | Sydney | Australia | 5 | None |
TicketID | Quantity | Price | ConcertID |
---|---|---|---|
(→ Concerts.ConcertID) | |||
1 | 5000 | 100 | 1 |
2 | 4000 | 80 | 1 |
3 | 3000 | 70 | 2 |
4 | 2000 | 60 | 3 |
5 | 1000 | 50 | 5 |