Question: Please make new diagram after solving this problem in this question, An orchestra keeps information about its musicians, its repertoire and concerts. A partial data
Please make new diagram after solving this problem in this question, An orchestra keeps information about its musicians, its repertoire and concerts. A partial data model is
shown in Figure The relationships store information such as that Joe Smith is required for Saturday's
concert and that Beethuven's violin sonata is to be performed at Saturday's concert.
Figure A partial data model for an orchestra's repertoire and concerts
What false information could be deduced from this initial model?
Amend the model so that it can maintain the following information correctly:
Which players are involved in particular works in a concert
The works being presented at a concert
The fee a player receives for appearing in a particular concert
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
