Please design an ER diagram for their database with the following information: Each musician has an SSN, a name, and an

[answerhappygod]

Please design an ER
diagram for their database with the following
information:
Each musician has an SSN, a name, and an address.
Each instrument used in songs recorded at Sac Music
Records has an identification number, a name (e.g., guitar,
flute) and a musical key (e.g., C, B-flat).
Each album has a title, a copyright date, a format (e.g., CD or
DVD), and an album identification number.
Each song has an identification number, title and an
author.
Each musician may play several instruments, and a given
instrument may be played by several musicians.
Each album has a number of songs on it, but no song may appear
on more than one album.
Each song is performed by one or more musicians, and a musician
may perform a number of songs.
Each album has exactly one musician who acts as its producer. A
musician may produce several albums, of course.
Notice: you must
specify the key attribute of each entity type
and the cardinality radio for each relationship
type. You may ignore participation constraints in this
problem.
Question
6 (15 points): Please convert the ER
diagram you obtained in to relation schemas. Please
underline all the primary keys and use arrows to
show all the foreign keys in the resulting
relation schemas.