## 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