Musician

IDNameYears_in_Industry
1John Doe20
2Jane Smith30
3Alice Johnson10
4Bob Brown15
5Charlie Davis5

Jazz_Musician

IDMusicianIDBandName
(→ Musician.ID)
11The Blue Notes
23The Green Trio
32The Red Quartet
45The Yellow Ensemble
54The Orange Septet

Rock_Guitarist

IDMusicianIDInstrumentAlbumCount
(→ Musician.ID)
11Electric Guitar8
22Acoustic Guitar7
33Electric Guitar9
44Bass Guitar6
55Drums5

Concert

IDDateVenueMusicalEventTypeHeadlinerIDOpeningActID
(→ Jazz_Musician.ID)(→ Rock_Guitarist.ID)
12023-01-15Madison Square GardenJazz Concert11
22023-02-20Carnegie HallClassic Rock Showcase22
32023-03-10Royal Albert HallBlues Night33
42023-04-05Barclays CenterProgressive Metal FestNone4
52023-05-15Wembley StadiumPop Extravaganza55