78%(9)7 out of 9 people found this document helpful
This preview shows page 1 - 2 out of 3 pages.
Another attribute is Conductor Name.SOLOISTSolo 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).Using ER Assistant or LucidChart, draw an ERD to represent what you have discovered.