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