| GenreID | Name |
|---|---|
| 1 | Rock |
| 2 | Jazz |
| 3 | Pop |
| 4 | Classical |
| 5 | Electronic |
| 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 |
| 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 |
| BandID | BandID_FK | Instrument |
|---|---|---|
| (→ Band.BandID) | ||
| 1 | 1 | Guitar |
| 2 | 2 | Drums |
| 3 | 3 | Bass Guitar |
| 4 | 4 | Keyboards |
| 5 | 5 | Vocals |