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 |