After completing a course in database management, you are asked to develop a preliminary ERD for a symphony orchestra. You discover the entity types that should be included as shown in Table 2-2.

• 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 preformed a given composition (Date last preformed).

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. Also to be included in this question numbers 1-5 Below.

1. Specify the primary key(s) in all tables, the foreign key(s) in dependent (child) tables, and all minimum and maximum cardinalities.

2. Highlight all composite and multivalued attributes where applicable.

3. All M:N relationships should be broken by introducing the associative entity.

4. For each direction of the relationship, use a verb or a short phrase to indicate the nature of the relationship (i.e. STUDENT --- Take --- CLASS).

5. If you are making certain assumptions regarding the business rules, please statement them explicitly above the ERD (i.e. a Publisher may publish multiple books but may have not yet published any books).

The season during which a series of concerts will be performed. Identifier is Opening Date, which indt TABLE 2-2 Entity Types for Problem and Exercise 23 CONCERT SEASON CONCERT Month, Day, and Year Apiven 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 concen typically has more than one concert date. 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. COMPOSITION 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. The season during which a series of concerts will be performed. Identifier is Opening Date, which indt TABLE 2-2 Entity Types for Problem and Exercise 23 CONCERT SEASON CONCERT Month, Day, and Year Apiven 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 concen typically has more than one concert date. 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. COMPOSITION 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