Artists

artistIDnamegenrenationality
1John DoeRockUSA
2Jane SmithPopUK
3Michael JohnsonCountryCanada
4Emily DavisHip HopAustralia
5David BrownElectronicNew Zealand

Albums

albumIDtitlereleaseDateartistID
(→ Artists.artistID)
1Debut Album2022-01-011
2Second Release2023-06-152
3Third Collection2022-11-173
4Fourth Studio2024-03-284
5Latest Creation2025-09-105

Songs

songIDtitledurationtrackNumberalbumID
(→ Albums.albumID)
1Song103:5011
2Song204:3021
3Song305:1032
4Song404:0543
5Song503:4054

InstrumentsUsedInSongs

instrumentsIDmusical_instrumentmanufacturerpricesongID
(→ Songs.songID)
1GuitarBonners Music10001
2GuitarAnother Company8002
3PianoBonners Music25003
4PianoYet Another Company24004