MUSICIAN RECORD

 

NOTOWN RECORD HAS DECIDED TO STORE INFORMATION ABOUT MUSICIANS WHO PERFORMED ON ITS ALBUMS IN A DATABASE .EACH MUSICIANS IDENTIFIED BY AN SSN, A NAME, AND AN AGE.EACH MUSICIANS LIVED IN DIFFERENT PLACES. PLACES ARE IDENTIFIED BY AN ADDRESS AND A PH.NO. EACH INSTRUMENTS 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 MUSICIANS PLAYED SEVERAL INSTRUMENTS AND A GIVEN INSTRUMENT PLAYED BY SEVERAL  MUSICIONS .EACH ALBUM HAS NO:OF SONGS ON IT, BUT NO SONG MAY APPEAR ON MORE THAN ONE ALBUM .EACH SONG IS PERFORMED BY ONE OR MORE MUSICIAN S 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.

 

 

 

 

 

 

 

 

 

1.0           MAPPING TO RELATIONAL MODEL

 

1.1 ENTITIES

 

 

1.1.1 MUSICIAN

 

SSN

AGE

M_NAME

 

 

 

 

 

 

 

1.1.2 PLACE

 

PH_NO

ADRESS

 

 

 

 

 

1.1.3 ALBUM

 

TITLE

FORMAT

DATE

 

 

 

 

 

                 

 

                 1.1.4  SONG

S_TITLE

AUTHOR

 

 

 

 

 

 

 

 

       1.1.5 INSTRUMENT

NAME

KEY

 

 

 

 

1.2    RELATIONSHIPS

 

 

 

1.2.1  LIVES

SSN

ADDRESS

 

 

 

 

1.2.2  PRODUCE

SSN

TITLE

 

 

 

 

 

1.2.3 APPEAR

TITLE

S_TITLE

   

 

 

 

 

1.2.4 PERFORM

SSN

S_TITLE

 

 

 

 

 

 

1.2.5 PLAY

SSN

NAME

   

 

 

Advertisements