This question is based on Section 2 of Block 2. It assesses your ability to transform an E-R conceptual model into a relational model. Figure 1 gives a fragment of the conceptual model for performances by bands at a 3-day music festival. Bands may make more than one performance during the festival. All performances take place on a single stage. The musicians in some bands may not be known at this point in time as some of the bands are re-forming with previous members from years gone by to celebrate the 40th anniversary of the festival. Bands and musicians may have confirmed their appearance, cancelled their appearance, or not yet replied to their invitation. The figure shows just the entity-relationship diagram, the entity types and an additional constraint. Entity-relationship diagram IsMemberOf Band Musician 0..1 0..* 1..1 0..* PlaysA TakesPartin Performance 0..* 0..* Entity types Band ( BandName, Confirmation Status ) Musician (MusicianName, AgentName, Confirmation Status ) Performance ( Date, Time) Additional constraint c.1 The Confirmation Status attribute of both Band and Musician can take three possible values: Confirmed, Cancelled, Pending. Figure 1 Fragment from Festival conceptual data model (b) Transform the fragment in Figure 1 into a corresponding relational representation. Do not forget to include suitable definitions for the domains of the attributes. (20 marks)