Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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?
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) YStep 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