Database Answers Harbour in Alaska

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Fishing Industry

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 not over-fishing. 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 last expedition
Barry says :- A. The Things of Interest include
  • A.1 Catches
  • A.2 Fishermen
  • A.3 Licences
  • A.4 Quotas
  • 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
    Home Ask a Question Careers Contact us Data Models First Timers Search Site Map