## Manufacturers

id | name
--- | ---
1 | Bonners Music
2 | Yamaha

## Musical_instruments

id | instrument_name | manufacturer_id
--- | --- | ---
|  | (→ Manufacturers.id)
1 | Guitar | 1
2 | Guitar | 2
3 | Piano | 1
4 | Piano | 2

## Artists

id | artist_name
--- | ---
1 | Artist A
2 | Artist B
3 | Artist C

## Albums

id | album_title | release_date | genre_id | artist_id
--- | --- | --- | --- | ---
|  |  | (→ Genre.id) | (→ Artists.id)
1 | Album 1 | 2021-01-01 | 1 | None
2 | Album 2 | 2021-02-02 | 2 | None
3 | Album 3 | 2021-03-03 | 3 | None

## Songs

id | song_name | artist_id | instrument_id
--- | --- | --- | ---
|  | (→ Artists.id) | (→ Musical_instruments.id)
1 | Song 1 | 1 | 1
2 | Song 2 | 2 | 2
3 | Song 3 | 3 | 1
4 | Song 4 | 1 | 2

## Album_Tracks

id | track_number | album_id | song_id
--- | --- | --- | ---
|  | (→ Albums.id) | (→ Songs.id)
1 | 1 | 1 | 1
2 | 2 | 1 | 2
3 | 3 | 2 | 3
4 | 4 | 2 | 4

## Genre

id | genre_type
--- | ---
1 | Genre 1
2 | Genre 2
3 | Genre 3