(Solved): ER Diagram with assumptions, relationships, cardinalities with primary keys in each entity and sup ...

ER Diagram with assumptions, relationships, cardinalities with primary keys in each entity and super/sub types if necessary.

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 the following table. 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. - For each concert there is one conductor. A conductor may conduct any number of concerts or may not conduct any concerts. - A soloist may perform one or more compositions at a given concert or may not perform any compositions. A composition may be performed at one or more concerts or may not be performed. Each composition may require one or more soloists or may not require a soloist. - The symphony orchestra also wishes to record the date when a soloist last performed a given composition (Date Last Performed).