QUESTION ONE The local fishing club hold a competition each year and it is open to all anglers registered with the National Anglers Federation. The competition takes place over a long weekend and there are local lakes chosen for the days. When each angler is registering for the competition, they are required to identify which club they are from and if they require accommodation for the weekend. If an angler requires accommodation, one of the competition committee members seeks out a suitable location and a host family is identified. This normally involves staying on all three nights over the weekend.

Once the competition starts on the Saturday morning, the details of the catch by each angler is recorded at the end of the day and the details of the lake are identified. The number of fish of each type are recorded as some fish have a higher value in the competition. The same process takes place on the Sunday and Monday and a leaderboard is drawn up by the committee each evening indicating the overall standings. There are a number of different prizes to be won: the top prize is for the angler who achieves the highest overall rating for the three days, taking into account the value of the fish caught. Prizewinners are included in the database for succeeding years so that a record is kept.

The committee require a database application for this competition. Draw an entity relationship diagram indicating the cardinality of the relationships between the entities. Document any assumptions you make.