Data Dictionary – Music Database

Data Dictionary – Music Database

 

Information about Artists – This information should include the name of the artist. An artist can be a band or a person who records music with a group of musicians.

Musical Release – Artists typically release music in album or single format. Formats have gotten more complex with the ability to release singles in digital format. Any musical release will have a specific data of release and the artist that released the music. An album is an example of a musical release.

Musicians – Musicians can play for multiple artists (bands or solo artists), or on specific songs. Musicians are identified by their names and the instruments that they play – they can play multiple instruments on a single song.

Songs – Songs are specific releases of a song. A song can be a single release or part of an album release (you need to keep track of this). Songs are recorded by an artist, and have multiple musicians working on them.