ArtistID | Name | Genre |
---|---|---|
1 | Artist A | Rock |
2 | Artist B | Jazz |
3 | Artist C | Pop |
PerformanceID | LivePerformance | Date | VenueID |
---|---|---|---|
(→ Venues.VenueID) | |||
1 | Concert | 2022-08-15 | 1 |
2 | Concert | 2022-09-16 | 2 |
3 | Theater Play | 2022-07-23 | 1 |
4 | Theater Play | 2022-08-05 | 2 |
VenueID | Name | Address | VenueCapacity |
---|---|---|---|
1 | Arena | Downtown | 500 |
2 | Hall | Uptown | 600 |
BookingID | PerformanceID | CustomerName | NumberOfTickets |
---|---|---|---|
(→ Performances.PerformanceID) | |||
1 | 1 | John Doe | 2 |
2 | 2 | Mary Smith | 3 |
3 | 3 | Alice Johnson | 4 |
4 | 4 | Bob Brown | 2 |