Artists

artist_idnamegenre
1Michael JacksonPop
2Elvis PresleyRock and Roll
3MadonnaPop
4PrincePop
5BeyonceR&B

Venues

venue_idnamelocation
1Wembley StadiumLondon
2Staples CenterLos Angeles
3Nissan StadiumNashville
4York ArenaNew York
5Hollywood BowlLos Angeles

Events

event_idartist_idvenue_idevent_date
(→ Artists.artist_id)(→ Venues.venue_id)
1112023-08-17
2222023-09-16
3332023-10-07
4442023-10-21
5552023-11-05

On_Sale_Date

sale_idevent_idstart_timeend_time
(→ Events.event_id)
1112:0023:59
2212:0023:59
3312:0023:59
4412:0023:59
5512:0023:59

Pre_sale_Date

presale_idevent_idstart_timeend_time
(→ Events.event_id)
1110:0017:00
2210:0017:00
3310:0017:00
4410:0017:00
5510:0017:00

Tickets

ticket_idevent_idseat_numberpriceON_SALE_DATE_IDPRESALE_DATE_ID
(→ Events.event_id)(→ On_Sale_Date.sale_id)(→ Pre_sale_Date.presale_id)
11A12011
21A22011
32A12022
43A12033
54A12044
65A12055