Transpose the E-R Diagram for RITPO into relations. Use the relational notation:  RELNAME( KeyAttr, Attr1, Attr2, FK ).  Italicize  or dash underline your foreign keys. Be sure to include a reference statement for each foreign key that follows the format : 

 

Transcribed Image Text:

NOTE: concert_number represents the number of the concerts within the season. Therefore concert numbers may be reused for each CONCERT SEASON. date opening_date name season year concert number time closing date composer_name gly compositionID composition_name date_last_solo CONCERT SEASON Scheduled CONCERT contains COMPOSITION has num_movements COMPOSITION_SOLOIST conducts/ conducted by city state JUNIOR level address level = 'J' has firstname street CONDUCTOR d zipcode conductor = 'Y' level = 'S' middle_initial mentors/ mentored by name MEMBER lastname SENIOR musician = 'Y' memberID num_concerts_conducted member_type MUSICIAN d SOLOIST musician? conductor? instruments NOTE: concert_number represents the number of the concerts within the season. Therefore concert numbers may be reused for each CONCERT SEASON. date opening_date name season year concert number time closing date composer_name gly compositionID composition_name date_last_solo CONCERT SEASON Scheduled CONCERT contains COMPOSITION has num_movements COMPOSITION_SOLOIST conducts/ conducted by city state JUNIOR level address level = 'J' has firstname street CONDUCTOR d zipcode conductor = 'Y' level = 'S' middle_initial mentors/ mentored by name MEMBER lastname SENIOR musician = 'Y' memberID num_concerts_conducted member_type MUSICIAN d SOLOIST musician? conductor? instruments