Build their own music-streaming website called musicmatic

Reference no: EM133225762

Question: Attracted by the success of Spotify, a group of students want to build their own music-streaming website called Musicmatic. Being economists, make EER diagram.

A large number of songs will be made available through their website, and the following information on each song needs to be stored: title, year, length, and genre. Also, artist information will be added, including date of birth, name, and a URL to a website (e.g., Wikipedia page) with additional information on the artist. You can assume an artist is uniquely identified by her name, and that a song always belongs to exactly one artist. The Musicmatic students also point out that songs having the same title are possible, and only the combination of song and artist can be assumed to be unique.

The database will also have to store information on the people using Musicmatic. It was decided to only discriminate between two types of users: regular users who will be able to buy music, and business users who will deliver the content (upload the music). The following information is recorded on each user: (unique) ID, name, and address. Business users will also have a tax id number.

The students want to offer a flexible service, and decided business users only can upload individual songs. These songs are classified either as singles or hits, and regular users can directly buy the singles. People can compose a playlist consisting of multiple hits (no singles). An playlist should be uniquely identifiable by an playlist number. The position of each hit in the playlist is stored as a track number in the database.

Finally, a user can be a regular user on some occasions (e.g., when downloading a single or album), and a business user at other times (e.g., when uploading self-made songs to Musicmatic).

Capture as much of the semantics of this situation as you can in an EER diagram!

Reference no: EM133225762

Questions Cloud

What are document databases : What are document databases and What are the key differences between relational and non-relational database structures

Nature of work : Nature of Work-Reflect on your own experiences and describe how the nature of work has changed thus far in your lifetime

Analyze the graph we obtained in lab : Analyze the graph we obtained in lab. Show the effect of RSVP on the Voice application and explain the obtained numbers of Path and Resv states.

Provides a brief but comprehensive overview of the goals : Provides a brief but comprehensive overview of the goals and objectives of the information assurance plan, including the importance of ensuring

Build their own music-streaming website called musicmatic : Capture as much of the semantics of this situation as you can in an EER diagram - build their own music-streaming website called Musicmatic.

Developing budget statement : Developing a budget statement In excel for mobile applications. Also explain working capital.

Develop a project network to implement the project plan : Develop a project network to implement the project plan, manage projects effectively, and complete required resource reallocation.

Define expatriate managers and domestic managers : Define expatriate managers and domestic managers using the literature.

Briefly discuss what risks these controls address : Briefly discuss what risks these controls address, and, in the case of controls in b), indicate why you have chosen not to address these risks.

User Account

All Pages