Another attribute is conductor name soloist solo

This preview shows page 1 - 2 out of 3 pages.

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). Using ER Assistant or LucidChart, draw an ERD to represent what you have discovered.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture