Musician
ID | Name | Years_in_Industry |
1 | John Doe | 20 |
2 | Jane Smith | 30 |
3 | Alice Johnson | 10 |
4 | Bob Brown | 15 |
5 | Charlie Davis | 5 |
Jazz_Musician
ID | MusicianID | BandName |
| (→ Musician.ID) | |
1 | 1 | The Blue Notes |
2 | 3 | The Green Trio |
3 | 2 | The Red Quartet |
4 | 5 | The Yellow Ensemble |
5 | 4 | The Orange Septet |
Rock_Guitarist
ID | MusicianID | Instrument | AlbumCount |
| (→ Musician.ID) | | |
1 | 1 | Electric Guitar | 8 |
2 | 2 | Acoustic Guitar | 7 |
3 | 3 | Electric Guitar | 9 |
4 | 4 | Bass Guitar | 6 |
5 | 5 | Drums | 5 |
Concert
ID | Date | Venue | MusicalEventType | HeadlinerID | OpeningActID |
| | | | (→ Jazz_Musician.ID) | (→ Rock_Guitarist.ID) |
1 | 2023-01-15 | Madison Square Garden | Jazz Concert | 1 | 1 |
2 | 2023-02-20 | Carnegie Hall | Classic Rock Showcase | 2 | 2 |
3 | 2023-03-10 | Royal Albert Hall | Blues Night | 3 | 3 |
4 | 2023-04-05 | Barclays Center | Progressive Metal Fest | None | 4 |
5 | 2023-05-15 | Wembley Stadium | Pop Extravaganza | 5 | 5 |