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 |