Artists

ArtistIDArtistName
1Adele
2Beyonce
3Michael Buble
4Elton John
5Justin Timberlake

Albums

AlbumIDYearMonthAlbumNameGenreArtistID
(→ Artists.ArtistID)
120191125Pop1
220164LemonadeR&B/Hip Hop2
3201311To Be LovedJazz3
4201811Captain Fantastic and The Brown Dirt CowboyRock4
520076FutureSex/LoveSoundR&B/Pop5

Songs

SongIDSongTitleDurationAlbumID
(→ Albums.AlbumID)
1Hello3061
2Formation2242
3Stronger2142
4All of Me2153
5Can You Feel the Love Tonight1824

MusicLabels

LabelIDLabelNameArtistID
(→ Artists.ArtistID)
1XL Recordings1
2Parkwood Entertainment2
3Republic Records5

Concerts

ConcertIDDateVenueCityCountryHeadlinerIDOpeningActID
(→ Artists.ArtistID)(→ Artists.ArtistID)
12020-12-31Madison Square GardenNew YorkUSA1None
22021-01-15Staples CenterLos AngelesUSA2None
32021-02-10O2 ArenaLondonUK3None
42021-02-20Barclays CentreBrooklynUSA4None
52021-03-05Sydney Opera HouseSydneyAustralia5None

Tickets

TicketIDQuantityPriceConcertID
(→ Concerts.ConcertID)
150001001
24000801
33000702
42000603
51000505