Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Database Technology Management For The Year 2000

Authors: Alan Simon

1st Edition

155860264X, 978-1558602649

More Books

Students also viewed these Databases questions

Question

3. Define the attributions we use to explain behavior

Answered: 1 week ago