(Solved): ER Design: Design an ER diagram in UML format for the following music database: An artist is a mus ...

ER Design: Design an ER diagram in UML format for the following music database: An artist is a musician who records songs. An artist has a record label. An artist is identified by an id that is specific to their record label. That is, each record label assigns its own ids. Also, record an artist's name and age. A record label has a unique name and an address. A song is recorded by one or more artists and is uniquely identified by an id field and has a title. A song is on one or more albums with a track number and duration. (Note: Assume an artist can put the same song on multiple albums, but any song change is given a new id.) An album is a collection of songs with a name. Track the number of sales of an album. An album may be associated with multiple artists and is identified by an UPC code. An artist on an album is given a number (first artist, second artist, etc.). An album is classified in a single genre (rap, classical, etc.). A genre is identified by name and has a description.