John has decided to organize his CD music collection. He wants to catalog his music by...

John has decided to organize his CD music collection. He wants to catalog his music by Album, Artist, Songwriter, and Song. An album is a compilation of songs. Songs are created when artists sing a song written by songwriters. John has noted that some songs appear multiple times in his catalog because they are on regular albums and compilation albums.

a) Write all of the assumptions regarding the music catalog.

b) Based on your assumptions, construct an ERD diagram. Be sure to indicate the entities and the type of relationships between the entities.

Solutions

Expert Solution

b) ERD for above database

venereology answered 9 months ago

Next > < Previous

Related Solutions

Harold has a collection of 20 movies that he wants to organize. a.There is a set...

Harold has a collection of 20 movies that he wants to organize. a.There is a set of small shelves that can store media at the foot of Harold’s bed. If each shelf can store up to 5 movies, how many different ways could movies be lined up on a shelf (if the shelf is going to be full)? b.A friend of Harold’s asked to borrow some movies. How many different ways can Harold lend his friend 3 movies? c.Unknown to...

Case #5: DJ John and his business of "Music on Wheels" John has started his second...

Case #5: DJ John and his business of "Music on Wheels" John has started his second year of the BAS at York University. John was not interested in working for others so he decided to start his own business with what is his passion: be a DJ in parties. A family friend that works as a lending officer in one of Canada's largest banks explained to him how the business plan has to be presented so he can get some...

6. John has a car he wants to sell. His goal is to get as much...

6. John has a car he wants to sell. His goal is to get as much as he can for the car (profit-maximizer). He lists the car in the local paper with no price – just “highest bidder” and announces a time to come by if interested. 3 potential buyers show up. Paul is willing to pay $1,000 for the car. George is willing to pay $2,000 for the car. Ringo is willing to pay $8,000 for the car. George...

John Nautilus has $1,200,000 and wants to retire. What return must his money earn so he...

John Nautilus has $1,200,000 and wants to retire. What return must his money earn so he may receive annual benefits of $80,000 at the end of each year for the next 30 years? 5.22% A 5.72% B 8.24% C 10% D

John Rider wants to accumulate $45,000 to be used for his daughter’s college education. He would...

John Rider wants to accumulate $45,000 to be used for his daughter’s college education. He would like to have the amount available on December 31, 2023. Assume that the funds will accumulate in a certificate of deposit paying 8% interest compounded annually. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Answer each of the following independent questions. Required: 1. If John were...

John Rider wants to accumulate $65,000 to be used for his daughter’s college education. He would...

John Rider wants to accumulate $65,000 to be used for his daughter’s college education. He would like to have the amount available on December 31, 2023. Assume that the funds will accumulate in a certificate of deposit paying 8% interest compounded annually. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Answer each of the following independent questions. Required: 1. If John were...

Michael will sell his bike because he will move and he has decided to sell it...

Michael will sell his bike because he will move and he has decided to sell it to the first person who offers at least 200 $. Suppose that each price offer given for Michael's bike is independent and exponentially distributed RVs(random variable) with mean $ 100 each. a) Michael sold his bike on the Kth offer. Find PMF(probability mass function) and mean of K b) Let the amount of offer which is sold by Michael be X $. Find PDF(Probability...

John really likes listening to music. His preferences for vintage records (?1) and music downloads (?2)...

John really likes listening to music. His preferences for vintage records (?1) and music downloads (?2) can be represented by the utility function ? = ?1?2. Initially, the price of a vintage record was $10, but it increased to $20 due to a new trend toward collecting vinyl. The price of a music download is $4 and John’s income is $240. How would you describe John’s preferences for vintage records and music downloads? The increase in the price of vintage...

Charles wants to relocate to Florida. He decided to sell his rental property, which is located in...

Charles wants to relocate to Florida. He decided to sell his rental property, which is located in Brooklyn, NY. Charles accepted the following terms: Charles received $1,200,000 in cash and was relieved of $800,000 mortgage. (this was the outstanding balance at the time the transaction closed). Charles was responsible for broker's fees and legal costs associated with transferring the mortgage of $35,000 and $17,500, respectively. Charles' adjusted basis in the rental property is $600,000. (The $600,000 is net of $750,000 of...

Ron decided to go with Bloom mutual fund. And he wants to simulate his returns had...

Ron decided to go with Bloom mutual fund. And he wants to simulate his returns had he invested in Bloom fund during the previous year. Ron was provided with the following information from Bloom regarding the previous year: Bloom started last year with a net asset value of $13 per share. And net asset value is $15 by year end. At the beginning of the year, the fund was selling at a premium of 5%, while by the end of...

Subjects