Question
Draw an ER/EER data model for the following scenario: You want to build a music database for a music streaming service similar to spotify or
Draw an ER/EER data model for the following scenario: You want to build a music database for a music streaming service similar to spotify or google music. For each music track, we will need to keep track of its name, the artist performing the track, the album the track performs on, and the time of the track. Some tracks have multiple artists. For some tracks, we will also separately note the composer (i.e. for classical music). Each album can contain multiple tracks, and may either be an album centered on one artist or may have tracks from multiple artists. Any track only appears on a single album (the same song appearing on multiple albums will be treated as multiple tracks). A track has a track number within the context of an album. Albums have a release date. Artists can be individuals (i.e. Michael Jackson), bands/groups (i.e. Led Zeppelin), or ensembles (i.e. the London Symphony Orchestra). Bands have members. Ensembles have leaders or composers. Individuals may appear in different roles on different albums (i.e. Michael Jackson as an individual or as a member of the Jackson Five). Albums may have labels (ex. Colombia) or may be independently produced by the artist (we need to know the difference for streaming royalties). Try to catch as much of this information in your ER diagram as possible. Add attributes as necessary. Note: it is ok to add auto-generated keys, but you should have keys noted in your diagram.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started