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 |