Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Provide the suitable ERD for the following system,(Entity Relationship Diagram) Q3- FIRST.FM Any assumptions must be explicitly listed. In this question, you are going to

image text in transcribed

Provide the suitable ERD for the following system,(Entity Relationship Diagram) Q3- FIRST.FM Any assumptions must be explicitly listed. In this question, you are going to design a database for an internet company called "First.fm". "First.fm" is a newly founded company which aims to use artificial intelligence techniques to understand its user's music preferences. Depending on the user's preferences, they will recommend the users similar songs that they might like. But as a first step, they need a simple database to make their tests. For this aim, they want you to design a database with the following properties. You will keep the information of your users in this database, such as a unique username, password, date of birth, gender and nationality. Each user may have performer list, album list, songs list and playlist. For each Performer, you should keep a unique name, ethnicity of the performer and the music type of the performer. A performer can perform more than one type. For each Album, you should keep the name of the album which is not unique, the year that the album is released and the number of songs in the album Each album also should keep track of the duration. A Performer may have released one or more Albums. But it is not necessary that each Performer should have released an Album For each Song, you should keep the name of the song which is not unique, the name of the composer of the song, a rating score for the song, type of the song, duration and a unique id. Each Song have to be included in more than one Album .Each user may create playlists. Those playlists consists of songs. Each playlists hold number of songs and name. A user may add another user's playlist into his/her playlist

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

Microsoft Visual Basic 2008 Comprehensive Concepts And Techniques

Authors: Gary B. Shelly, Corinne Hoisington

1st Edition

1423927168, 978-1423927167

More Books

Students also viewed these Databases questions

Question

Give examples of two cost objects in companies using job costing?

Answered: 1 week ago

Question

600 lb 20 0.5 ft 30 30 5 ft

Answered: 1 week ago

Question

1. What might have led to the misinformation?

Answered: 1 week ago