## 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