Artists

ArtistIDArtistName
1Adele
2Beyonce
3Elton John
4Justin Timberlake
5Lady Gaga

Albums

AlbumIDAlbumTitleReleaseDateARTISTID
(→ Artists.ArtistID)
1212011-02-241
2Beyonce2016-04-072
3Goodbye Yellow Brick Road1973-05-083
4FutureSex/LoveSound2006-11-124
5The Fame2008-09-015

Tickets

TicketIDEventIDQuantityOn_Sale_DatePre_sale_DatePrice
(→ Events.EventID)
111002023-06-012023-06-1549.99
222002023-07-012023-07-1559.99
331502023-08-012023-08-1569.99
442502023-09-012023-09-1579.99
553002023-10-012023-10-1589.99

Venues

VenueIDNameAddress
1Madison Square GardenNew York, NY
2Staples CenterLos Angeles, CA
3Wembley StadiumLondon, UK
4Royal ArenaCopenhagen, Denmark
5Barclays CentreBrooklyn, NY

Events

EventIDEventNameStartDateTimeEndDateTimeVenueIDTICKETID
(→ Venues.VenueID)(→ Tickets.TicketID)
1Adele Concert2023-06-10 19:00:002023-06-10 22:30:0011
2Beyonce World Tour2023-07-15 20:00:002023-07-15 23:30:0022
3Elton John Farewell Tour2023-08-20 19:00:002023-08-20 22:30:0033
4Justin Timberlake Man Of The Woods Tour2023-09-15 20:00:002023-09-15 23:30:0044
5Lady Gaga Jazz & Piano Tour2023-10-20 19:00:002023-10-20 22:30:0055

Performances

PerformanceIDEventIDArtistIDPerformanceStartTimePerformanceEndTime
(→ Events.EventID)(→ Artists.ArtistID)
1112023-06-10 19:30:002023-06-10 22:00:00
2222023-07-15 20:30:002023-07-15 23:00:00
3332023-08-20 19:30:002023-08-20 22:00:00
4442023-09-15 20:30:002023-09-15 23:00:00
5552023-10-20 19:30:002023-10-20 22:00:00