Draw an entity-relationship diagram to represent information relating to a database to be used to store information for a (music) production company. The database is to record information about artists. An artist is the name of a singer or band; the unique name of the artist, the date the artist started recording, the number of members of the artist and the genre of music it plays are to be recorded. For example, the artist Queen (yes, I'm not even pretending to be up to date) was formed in 1970, had four members and played rock.

In addition to the information about artists the database will also record information about the members of an artist (referred to as musicians). The (unique) SIN, first name, last name, instrument and email address of musicians is to be recorded. An artist must be associated with at least one musician (a solo artist), although may be associated with more. Musicians that are not associated with artists will not be maintained in the database, and a musician may be associated with more than one artist. The database should also record the share of the revenue that a musician receives from songs recorded by an artist that the musician is associated with. If a musician is associated with more than one artist they may have different shares from each artist. For example, Ian Gillan might receive 30% of the revenue from songs recorded by Deep Purple, and 80% of the revenue from songs recorded by Gillan. The following information is to be recorded for songs the unique ISRC (International Standard Recording Code), the song's title, its duration, the year that it was recorded and the name of the song's album. Songs are recorded by artists, an artist can record more than one song, and each song must be recorded by just one artist. Since the database may record artists who just starting out an artist does not have to have recorded a song. Monthly sales of songs will also be recorded. For each month, year, vendor and country the number of songs sold and the total sale amount are to be recorded. For example the song "Call Me Maybe" might be sold by iTunes Canada , iTunes UK, and Amazon Canada in May 2013, so would require three sales entries that record the number of songs sold and the total amounts for those vendors and countries in that month. A song may be sold many times (or not at all). The recording studio assigns each musician associated with an artist a representative (rep). A musician is assigned at most one rep for each artist that they are a part of (and may not be assigned any reps at all). A rep must be assigned to at least one musician, and can be assigned to multiple musicians or even the same musician more than once if that musician is associated with multiple artists. A studio representative has a (unique) SIN, first name, last name, studio name and phone number. For example Ian Gillan might be associated with rep Bob for Deep Purple and rep Kate for Gillan. Finally the writers of songs are to be recorded. A song may have more than one writer, but must have at least one. Writers of songs not in the database (or prospective writers) will not be recorded. A song writer may write many songs. In addition to the writers' SINs, first names and last names the percentage royalty that they earn for each song should be recorded. These royalty percentages may vary from song to song. A. Construct an entity-relationships diagram (ERD) using MySQL Workbench for the entities in question A and ensure that you have correctly defined the minimum and maximum cardinalities, identifying and non-identifying relationships.

B. Please make sure that you clearly state your assumption.