Question 4 (1 point) A rock and roll band wants a database to keep track of their performances and songs played at those performances. A performance consists of a number of sets (typically three or four) during which specific songs are played in a specific order. The database will be used to print set lists for the musicians when they perform. A set list shows the songs to be performed in the order in which they will be performed. The database will also keep track of what musical instruments are needed for particular songs. This will allow the band manager to make sure that the right instruments are available for performances. Here is a partial list of attributes that the database designer thinks needs to be stored in the database but some essential ones might still be missing. The comments indicate what the attribute means. pid //unique id for performance date //performance date time //performance start time address //performance venue address contact Iame of contact person at venue expected //expected audience size at performance actual //actual audience size at performance title //title of a performed song composer l/composer of a performed song publisher // publisher of a performed song sid //unique id for a performed song instrument /ame of an musical instrument instrument /ame of an musical instrument id //unique id for a musical instrument Which ONE of the following ER models best captures the basic requirements described above? SetN Order No PERFORMANCE Pid Date Time Address Contact Expected Actual Played AT N:N SONG Sid Title Composer publisher id VenuelD SetN Order No PERFORMANCE Pid Date Time Address Contact Expected Actual SONG Sid Title Composer publisher Played AT N:N Needed N:N INSTRUMENT ID instrument SetN Order No INSTRUMENT ID instrument SONG Sid Title Composer publisher Needed N:N PERFORMANCE Pid Date Time Address Contact Expected Actual Played AT N:N Order No PERFORMANCE Pid Date Time Address Contact Expected Actual PlayedAT N:N SONG Sid Title Composer publisher SetN Needed 1:N INSTRUMENT ID instrument Played AT N:N PERFORMANCE Pid Date Time Address Contact Expected Actual SONG Sid Title Composer Publisher Set Number Order No Needed N:N INSTRUMENT ID instrument