## Genre

GenreID | Name
--- | ---
1 | Rock
2 | Jazz
3 | Pop
4 | Classical
5 | Electronic

## Band

BandID | Name | FoundingYear | GenreID
--- | --- | --- | ---
|  |  | (→ Genre.GenreID)
1 | The Beatles | 1960 | 1
2 | Miles Davis Quintet | 1985 | 2
3 | Pink Floyd | 1965 | 3
4 | Led Zeppelin | 1968 | 4
5 | Nirvana | 1987 | 5

## JazzBand

BandID | BandID_FK | JazzStyle
--- | --- | ---
| (→ Band.BandID) |
1 | 1 | Bebop
2 | 2 | Cool Jazz
3 | 3 | Free Jazz
4 | 4 | Hard Bop
5 | 5 | Modern Jazz

## RockBand

BandID | BandID_FK | Instrument
--- | --- | ---
| (→ Band.BandID) |
1 | 1 | Guitar
2 | 2 | Drums
3 | 3 | Bass Guitar
4 | 4 | Keyboards
5 | 5 | Vocals