Musicians
id | name | musician_type |
1 | John Doe | Country Singer |
2 | Jane Smith | Country Singer |
3 | Bob Johnson | Bluegrass Singer |
4 | Alice Brown | Bluegrass Singer |
5 | Tom Green | Rock Star |
6 | Emily White | Pop Singer |
Instruments
id | instrument_name |
1 | Guitar |
2 | Violin |
3 | Piano |
4 | Drums |
5 | Bass Guitar |
Songs
id | song_title | release_date |
1 | My Favorite Song | 2018-07-01 |
2 | Another Great Song | 2019-06-30 |
3 | Awesome Tune | 2020-05-15 |
4 | Amazing Melody | 2021-04-10 |
5 | Fantastic Track | 2022-03-01 |
Albums
id | album_title | release_year | artist_id |
| | | (→ Musicians.id) |
1 | First Album | 2010 | 1 |
2 | Second Album | 2011 | 1 |
3 | Third Album | 2012 | 2 |
4 | Fourth Album | 2013 | 2 |
5 | Fifth Album | 2014 | 3 |
SongAlbum
id | song_id | album_id |
| (→ Songs.id) | (→ Albums.id) |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
MusicianInstrument
id | musician_id | instrument_id |
| (→ Musicians.id) | (→ Instruments.id) |
1 | 1 | 1 |
2 | 1 | 2 |
3 | 2 | 3 |
4 | 3 | 1 |
5 | 4 | 4 |