Genre

GenreIDName
1Rock
2Jazz
3Pop
4Classical
5Electronic

Band

BandIDNameFoundingYearGenreID
(→ Genre.GenreID)
1The Beatles19601
2Miles Davis Quintet19852
3Pink Floyd19653
4Led Zeppelin19684
5Nirvana19875

JazzBand

BandIDBandID_FKJazzStyle
(→ Band.BandID)
11Bebop
22Cool Jazz
33Free Jazz
44Hard Bop
55Modern Jazz

RockBand

BandIDBandID_FKInstrument
(→ Band.BandID)
11Guitar
22Drums
33Bass Guitar
44Keyboards
55Vocals