Databases

Draw a normalized E-R diagram for the opera house relations shown below. Do not leave any N:M relationships in the final version. List the main attributes for the final entities, and indicate primary keys and foreign keys.

SEASON - The season during which a series of concerts will be performed. Identifier is OpeningDate.

CONCERT A musical performance of one or more musical compositions. Identifier is ConcertNumber. Each concert typically has several performances on different dates, so both the date and the time are recorded for each performance of a concert. COMPOSITION Compositions to be played at each concert. Identifier is the combination of the ComposerName and the CompositionName. CONDUCTOR Person who will conduct the concert. Identifier is ConductorID. Another attribute is ConductorName. SOLOIST Solo artist who have a solo in a given composition for a particular concert. Identifier is SoloistID. Another attribute is SolistName.

Assumptions: A concert season schedules one or more concerts. A particular concert is scheduled for only one season. A concert included the performance of one or more compositions. A composition may be performed at several concerts. For each concert, there is one conductor. A conductor may conduct several concerts, but a conductor conducts all performances of a given concert. Each composition may require one or more soloists, or may not require a soloist. A soloist may have a solo in one or more compositions at a given concert, or may not perform any composition for a given concert. The orchestra wishes to record the date when a soloist last performed a given composition (DateLastPerformed). Also, list any additional assumptions you made in answering this question.