Question: Hi can you explain how to solve this question? Task #1 (12 points]MUSIC(Title, Artist, NumGrpMenibers, Year, Producer, ProducerURL, Category, CategorySales, Media, MediaPrice ) Business Rules:

Hi can you explain how to solve this question?

Hi can you explain how to solve this question? Task #1 (12

Task #1 (12 points]MUSIC(Title, Artist, NumGrpMenibers, Year, Producer, ProducerURL, Category, CategorySales, Media, MediaPrice ) Business Rules: 1. 2. 99:45:"?le S9 Each "album" (CD) is uniquely identified by its title. Note that, for the rest of the businessrules, the "Title" attribute of MUSIC refers to the name of the "album". An artist may either be a single person or a band made up of multiple members (the countbeing recorded in NumGrpMembers, which can be 1). Each album has one release year. Each album is produced by one music production company (producer). Each producer has one company URL. A specific album has only one artist. Each album is classified into one music category (Rock, Country, etc.) Each category is associated with one category sales value, which is the year-to—date sales forthat given category. For convenience, the music company sells all of its music at the same price based on themedia type. For example, all cassettes are $9.99, all CD5 are $16.99, etc. List ALL functional dependencies for the MUSIC relation above, according only to the business ruleslisted. Use the format A [l B. Then, for each functional dependency denote with a 'Y' or 'N' if therespective functional dependency causes 2NF or 3NF violation in the MUSIC relation. Functional Dependencies 3NF violation? Title -> Artist Y (partial dep) N (not violatingtrans) Artist -> NumGrpMembers N(artist not in pk) Y

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!