Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribed 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

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_2

Step: 3

blur-text-image_3

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

Accounting

Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac

25th edition

978-1285069609, 1285069609, 978-1133607601

More Books

Students also viewed these Accounting questions