EventID | Title | Date | Time | VenueName | Live_Performance | Venue_Capacity |
---|---|---|---|---|---|---|
1 | Rock Concert | 2021-12-31 | 19:00:00 | Citi Field | Concert | 500 |
2 | Classical Music Night | 2021-12-31 | 18:00:00 | Carnegie Hall | Concert | 600 |
3 | A Midsummer Night's Dream | 2022-05-27 | 19:00:00 | Central Park | Theater Play | 500 |
4 | Hamlet | 2022-05-27 | 18:00:00 | Broadway Theatre | Theater Play | 700 |
ArtistID | Name | Genre |
---|---|---|
1 | Band A | Pop |
2 | Band B | Rock |
3 | Band C | Jazz |
4 | Band D | Country |
5 | Band E | Hip Hop |
PlayID | Title | Author | Year |
---|---|---|---|
1 | Othello | Shakespeare | 1603 |
2 | Macbeth | Shakespeare | 1606 |
3 | King Lear | Shakespeare | 1606 |
4 | Antony and Cleopatra | Shakespeare | 1607 |
5 | Twelfth Night | Shakespeare | 1602 |
ConcertID | Band_or_Artist_name | Album |
---|---|---|
1 | Band X | Album Y |
2 | Band Z | Album W |
3 | Band AA | Album BB |
4 | Band AB | Album BA |
5 | Band AC | Album CA |
ConcertID | ArtistID |
---|---|
(→ Concert.ConcertID) | (→ Artist.ArtistID) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
PlayID | VenueName |
---|---|
(→ Theater_Play.PlayID) | (→ Live_Event.VenueName) |
1 | Central Park |
2 | Broadway Theatre |
3 | Central Park |
4 | Broadway Theatre |
5 | Central Park |