ArtistID | ArtistName |
---|---|
1 | Adele |
2 | Beyonce |
3 | Elton John |
4 | Justin Timberlake |
5 | Lady Gaga |
AlbumID | AlbumTitle | ReleaseDate | ARTISTID |
---|---|---|---|
(→ Artists.ArtistID) | |||
1 | 21 | 2011-02-24 | 1 |
2 | Beyonce | 2016-04-07 | 2 |
3 | Goodbye Yellow Brick Road | 1973-05-08 | 3 |
4 | FutureSex/LoveSound | 2006-11-12 | 4 |
5 | The Fame | 2008-09-01 | 5 |
TicketID | EventID | Quantity | On_Sale_Date | Pre_sale_Date | Price |
---|---|---|---|---|---|
(→ Events.EventID) | |||||
1 | 1 | 100 | 2023-06-01 | 2023-06-15 | 49.99 |
2 | 2 | 200 | 2023-07-01 | 2023-07-15 | 59.99 |
3 | 3 | 150 | 2023-08-01 | 2023-08-15 | 69.99 |
4 | 4 | 250 | 2023-09-01 | 2023-09-15 | 79.99 |
5 | 5 | 300 | 2023-10-01 | 2023-10-15 | 89.99 |
VenueID | Name | Address |
---|---|---|
1 | Madison Square Garden | New York, NY |
2 | Staples Center | Los Angeles, CA |
3 | Wembley Stadium | London, UK |
4 | Royal Arena | Copenhagen, Denmark |
5 | Barclays Centre | Brooklyn, NY |
EventID | EventName | StartDateTime | EndDateTime | VenueID | TICKETID |
---|---|---|---|---|---|
(→ Venues.VenueID) | (→ Tickets.TicketID) | ||||
1 | Adele Concert | 2023-06-10 19:00:00 | 2023-06-10 22:30:00 | 1 | 1 |
2 | Beyonce World Tour | 2023-07-15 20:00:00 | 2023-07-15 23:30:00 | 2 | 2 |
3 | Elton John Farewell Tour | 2023-08-20 19:00:00 | 2023-08-20 22:30:00 | 3 | 3 |
4 | Justin Timberlake Man Of The Woods Tour | 2023-09-15 20:00:00 | 2023-09-15 23:30:00 | 4 | 4 |
5 | Lady Gaga Jazz & Piano Tour | 2023-10-20 19:00:00 | 2023-10-20 22:30:00 | 5 | 5 |
PerformanceID | EventID | ArtistID | PerformanceStartTime | PerformanceEndTime |
---|---|---|---|---|
(→ Events.EventID) | (→ Artists.ArtistID) | |||
1 | 1 | 1 | 2023-06-10 19:30:00 | 2023-06-10 22:00:00 |
2 | 2 | 2 | 2023-07-15 20:30:00 | 2023-07-15 23:00:00 |
3 | 3 | 3 | 2023-08-20 19:30:00 | 2023-08-20 22:00:00 |
4 | 4 | 4 | 2023-09-15 20:30:00 | 2023-09-15 23:00:00 |
5 | 5 | 5 | 2023-10-20 19:30:00 | 2023-10-20 22:00:00 |