a Question 5 (10 points): Sac Music Records stores information about musicians who perform on their albums in a database

[answerhappygod]

A Question 5 10 Points Sac Music Records Stores Information About Musicians Who Perform On Their Albums In A Database 1 (40.94 KiB) Viewed 40 times

a Question 5 (10 points): Sac Music Records stores information about musicians who perform on their albums in a database. 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.