Consider the following scenario and draw an E-R diagram for Mozar. Mozar has decided to store information about musicians who perform on its albums (as well as other company data) in a database. Each album that is recorded on the Mozar label has a title, a copyright date, a format (e.g., CD or MC), and an album identifier. Each album has a number of songs on it, but no song may appear on more than one album.Each album has exactly one musician who acts as its producer. A musician may produce several albums, of course. Each musician that records at Mozar has a SerialNo, a name, an address, and a phone number. Each address is made up of a street, a city and a postcode. Each musician may play several instruments, and a given instrument may be played by several musicians. Each instrument that is used in songs recorded at Mozar has an instrumentID, name (e.g., guitar, piano, flute) and a musical key (e.g., C, B-flat, E-flat). Each song is performed by one or more musicians, and a musician may perform a number of songs. Each song recorded at Mozar has a title and an author
Consider the following scenario and draw an E-R diagram for Mozar.
Mozar has decided to store information about musicians who perform on its albums (as well as other company data) in a
Each instrument that is used in songs recorded at Mozar has an instrumentID, name (e.g., guitar, piano, flute) and a musical key (e.g., C, B-flat, E-flat). Each song is performed by one or more musicians, and a musician may perform a number of songs. Each song recorded at Mozar has a title and an author
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images