In: Computer Science
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.