Back to the Data Model.
The Area being Modelled is :-
Fishing Industry monitored by Governmental Agency
A new Governmental Agency has been set up to monitor the fishing industry in this Region.
The concern is that over-fishing might lead to the eventual extinction of some species and
great problems for those people who depend on seafood for their survival.
TheAgency wants a Database to store the data necessary to monitor the situation.
All commercial fishermen within the Region must have a licence to fish which is granted
each year by the Agency.
Records of all licences issued over the last 5 years must be maintained in the Database.
A register of all major species of Fish, identified by the government species code, is to
be kept and is to be regularly updated with the population surveys of each species which
will be carried out by theAgency's scientists.
The scientists will work out a "minimum population" figure and a "total catch" figure, for
each calendar year, for each species.
Each licenced commercial fisherman must apply to the Agency annually for quotas which specifies
the amount of each species of seafood that the fisherperson can catch in a particular year.
A catch report must be made by each commercial fisherperson listing the tonnage of each species
caught on each fishing expedition.
The fisherman also provides a brief weather description for each expedition and the boat name.
The Agency has inspectors who do random audits to ensure that the catch reports are accurate.
These reports are to be stored so that the quotas can be checked to ensure that fishermen are
The system will produce regular reports of trends in species populations and exception reports
where the population seems to be falling rapidly, or it is approaching the "minimum population" levels,
or where the population surveys do not match the catch reports.
One type of report is shown below for mr john snapper.
Note that there are several other types of reports.
Fisherman Name : Mr John Snapper
Licence Nr : 7373
Address : 18 mermaid st geelong
Phone : (03) 224556
species no. e Number :
Species quota quota limit ytd_catch balance 234
tuna 548351842 15,000 11,125 3,875 236
ling 548354821 10,000 5,563 4,437 452
trout 548351452 20,000 12,458 7,542
Barry says :-
A. The Things of Interest include
A.5 Species of Fish
A.6 Others to be determined
B. What do we know about The Things of Interest ?
B.1 Each Fishermen has a Quota.
B.2 Each Species of Fish has a Quota.
B.3 Others to be determined
© DataBase Answers Ltd. 2009