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
Get step-by-step solutions from verified subject matter experts
