Notown Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database. The company has wisely chosen to hire you as a database designer (at your usual consulting fee of $2,500/day).

Your current job is to map the following ER diagram in to a relational schema. Please clearly mark the primary and foreign keys and indicate cardinality of tables.

Name SSN IID Name Address Key Musician Plays Instrument Phone Performs Produces Date Album Contains Song Author AID Format SID Title Title