Question
Newtown Records has determined to store information about musicians who perform on its albums in a database. The company has wisely chosen to hire you as a database designer (at your usual consulting fee of $2500/day).
1. Each musician that records at Newtown has an SSN, a name, an address, and a phone number. Badly paid musicians often share the same address, and no address has more than one phone.
2. Each instrument used in songs recorded at Newtown has a unique identification number, a name as in guitar, synthesizer, flute and a musical key (e.g., C, B-flat, E-flat).
3. Each album recorded on Newtown label has a unique identification number, a title, a copyright date, a format such as CD or MC and an album identifier.
4. Each song recorded at Newtown has a title and an author.
5. Each musician might play several instruments, and a given instrument may be played by several musicians.
6. Each album has a number of songs on it, but no song may appear on more than one album.
7. Each song is performed by one or more musicians, and a musician could perform a number of songs.
8. Each album has approximately one musician who acts as its producer. A musician can produce several albums, of course.
The preceding information describes situation that the Newtown database must model. Plan an ER diagram for this application. Be sure to indicate all key attribute and cardinality and participation constraints and any assumptions you make.
The ER diagram is already designed in the attached file. Redraw diagram using your own way you be able to make it colorful id you want.