fisherpersons are not over-fishing, Computer Engineering

Prepare the Relational Tables to signify the following situation, which is defined by means of text and an Entity Relationship Diagram.

Note: Do not attempt to vary the ERD. Your task is to state the relational tables which fit the given ERD.

The NSW government has agreed to set up an organisation to monitor the fishing industry in this state. 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. The organisation wants a computer based information system to store the data necessary to monitor the situation.

All commercial fisherpersons within the state must have a licence to fish which is granted each year by the organization. Records of all licences issued over the last 5 year's must be maintained by the system.

A register of all main species, identified by the government species code, is to be reserved and is to be regularly updated with the population surveys of every  species which will be carried out by the organisation's scientists. The scientists will work out a "minimum population" figure and a "total catch" figure, for every calendar year, for every species.

Every licenced commercial fisherperson must apply to the organisation annually for quotas which specifies the amount of every species of seafood that the fisherperson can catch in a particular year. A catch report must be made by every commercial fisherperson listing the tonnage of every species caught on every fishing expedition. The fisherperson also gives a brief weather description for each expedition and the boat name. The organisation 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 make sure that fisherpersons are not over-fishing.

The system will generate regular reports of trends in species populations and exception reports where the population seems to be declining 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 various other types of reports.)




Posted Date: 3/18/2013 1:51:03 AM | Location : United States

Related Discussions:- fisherpersons are not over-fishing, Assignment Help, Ask Question on fisherpersons are not over-fishing, Get Answer, Expert's Help, fisherpersons are not over-fishing Discussions

Write discussion on fisherpersons are not over-fishing
Your posts are moderated
Related Questions
Explain at least one modulation technique used for high speed modems. FSK - Frequency Shift Keying: In such technique the frequency of the carrier signal is changed as per to

Q. How do you classify the neutrons in terms of its kinetic energy? Neutrons are classified as-per to their kinetic energy as (a) Slow neutrons as well as (b) fast neutrons.

Convert binary number in two's compliment form 0100 1000. Converting the binary number into 2's compliment from 0100 1000 is given below: 01001000 => 10111000

Non-Uniform Memory Access Model (NUMA) In shared memory multiprocessor systems, local memories can be joined with every processor. The group of every local memories form the gl

Q. How to select a table? The easiest way to select a table in Standard view is by using tag selector, which displays HTML tags of elements in document. You will use tag sel

Explain the term- Cycle Based Simulator This is a Digital Logic Simulation method which eliminates unnecessary calculations to achieve huge performance gains in verifying Bool

List the criteria on the basis of which data structures used in language processing can be classified. In language processing the data structures utilization can be classified

Which header file is used for screen handling function:- The header files stdio.h having definitions of constants, macros and types, along with function declarations for stan

Explain the Structure of Virtual Enterprise. The virtual enterprise can be a suitable structure to explore the emerging opportunities for forming value in the information socie

Define DMA. The transfer of data among a fast storage device such as magnetic disk and memory if often limited by the speed of the CPU. Removing the CPU from the path and letti