After completing a course in database management, you are asked to develop a preliminary ERD for a

Question:

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-3.
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).
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Modern Database Management

ISBN: 978-0133544619

12th edition

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

Question Posted: