Question: Draw a conceptual data model to model the scenario in each problem. Be sure to include all appropriate completeness constraints, disjointness constraints, and subtype indicators

Draw a conceptual data model to model the scenario in each problem. Be sure to include all appropriate completeness constraints, disjointness constraints, and subtype indicators in your conceptual data models.

The Southcentral Illinois Orchestra (SIO) performs in a number of different cities each year. SIO employs a number of different musicians each of whom performs in many, but not all, of the songs that SIO plays in its concerts. Each song is played by one or more musician, and each musician performs in one or more song. Attributes of musician include MusicianID, MusicianName (composed of FirstName, MiddleInitial, and LastName), Birthdate, Age, Salary, and Instruments. Many musicians play more than one instrument. Attributes of song include SongID, SongName, Composer, and Duration. A performance consists of one or more songs. Attributes of concert include ConcertNumber, StartDate, EndDate, and City. A song can be included in one or more concert.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!