An orchestra keeps information about its musicians, its repertoire and concerts. A partial data model is

shown in Figure $5-22.$ 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 $5-22.$ 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