Question: Write or draw the relations that would make up the logical design for the problem below. Use arrows to label the referential integrity constraints in

Write or draw the relations that would make up the logical design for the problem below. Use arrows to label the referential integrity constraints in your answers. Underline the primary keys in your answers with solid underlines

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!