Table $2-3$ Entity Types for Problem and Exercise $2-45$

CONCERT SEASON

The season during which a series of concerts will be performed. Identifier is Opening Date, which includes Month, Day, and Year.

CONCERT

A given performance of one or more compositions. Identifier is Concert Number. Another important attribute is Concert Date, which consists of the following: Month, Day, Year, and Time. Each concert typically has more than one concert date.

COMPOSITION

Compositions to be performed at each concert. Identifier is Composition ID$,$ which consists of the following: Composer Name and Composition Name. Another attribute is Movement ID$,$ which consists of two parts: Movement Number and Movement Name. Many, but not all, compositions have multiple movements.

CONDUCTOR

Person who will conduct the concert. Identifier is Conductor ID$.$ Another attribute is Conductor Name.

SOLOIST

Solo artist who performs a given composition on a particular concert. Identifier is Soloist ID$.$ Another attribute is Soloist Name.

During further discussions you discover the following:

A concert season schedules one or more concerts. A particular concert is scheduled for only one concert season.

A concert includes the performance of one or more compositions. A composition may be performed at one or more concerts or may not be performed.

For each concert there is one conductor. A conductor may conduct any number of concerts or may not conduct any concerts.

Each composition may require one or more soloists or may not require a soloist. A soloist may perform one or more compositions at a given concert or may not perform any composition. The symphony orchestra wishes to record the date when a soloist last performed a given composition $($Date Last Performed$).$

Draw an ERD to represent what you have discovered. Identify a business rule in this description and explain how this business rule is modeled on the E$-$R diagram. Also draw a data model for this situation using the tool you have been told to use in your course.