Notown record has decided to store information about musicians who perform on its albums in a database.Each musician identified by an ssn,a name and an age.Each musician lived in different places.Places are identified by an address and a ph.no.Each instrument is identified by a name and a key.Each album has a title ,date and a format.Each song has a title and an author.Each musician play several instruments and a given instrument played by several musicians.Each album has no:of songs on it,but no song may appear on more than one album.Each song is performed by oe or more musicians and a musician may perform a no:of songs.Each album has exactly one musician who acts its producer.A musician may produce several albums.DRAW ER DIAGRAM.

B1

step2:Find relations

A1

A2

A3

A4

A5

STEP3:Identify key attribute

Musician:SSN

Place:address

Album:title

Song:author

Instrument:name

 

STEP4:Identify other relevant attributes

Musician:m_name,age

Place:ph.no

Album:date,format

Song:s_title

Instrument:key

 

STEP5:Complete ER diagram

M1

Advertisements