LAB $2$

Exercise $[$CLO $2\mathrm{.}1]$

An underwater hunting club wants to computerize the results of hunting parties.

All fishermen of the club are known under a nickname and provide their last

names, first names, addresses, phone numbers, dates of birth and years of experience.

Hunting parties are not common $($each fisherman hunt individually$).$ we consider

that there can be only one hunt per person in the same day. Each party $($hunt$)$ admits a number.

The species are classified according to their level of shooting $($difficulty they present to be hunted$),$ their average weight and name.

When the result of a hunt is recorded, only the number of fish per species is counted $($the fish are not weighed: we always reason from the average weight$).$

Finally, at each level of shooting is associated a number of points $($the higher the

level, the greater the number of points is important$),$ which allows to assign a

score to each hunting party.

The purpose of the club is to enable the following documents to be established:

the inventory of fish species and the level of fire allocated to them

the summary of the number of catches in the year for all the hunters of the club

the balance of the hunting parties for a given hunter

$($NB: we want to see the place where each hunt took place$).$

The IT system administrator can manage all system components, manage and assign user access rights, such as competition managers. These latter manage competitions and scores.