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.)

 

1461_55.png

685_55.png

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
Q. What is Associative Mapping Cache? The most fastest and flexible cache organization employs an associative memory that is displayed in Figure below. The associative memory s

Q. Standards for scan codes ? There are 3 standards for scan codes: Mode1 (83-key keyboard PC, PC-XT) and Mode2 (84-key AT keyboard) and Mode3 (101-key keyboard onwards). In Mo

Define the term busy hour Busy Hour: Continuous 1- hour period lying completely in the time interval concerned, for that the traffic volume or the number of calls attempts is

What is relational database? Relational database has data that is perceived as tables. A relational DBMS manages tables of data and associated structures that enhances the func

Q Use as few gates as possible, design a NAND-to-AND gate network that realize the following Boolean algebra expression. ABCD + A'BC'D + A'BC'D' + A'BCD + (A'B'C'D' + A'BCD')

Q. What is Cache Memory? Cache memory is a very fast and small memory between CPU and main memory whose access time is closer to processing speed of CPU. It behaves as a high-s

Define Memory Latency? It is used to refer to the amount of time it takes to transfer a word of data to or from the memory.

What are the roll and page areas? Roll and page areas are SAP R/3 buffers used to kept user contexts (process requests).  The SAP dispatcher assigns procedure requests to work

Define locality of reference? What are its types?  During the course of implementation of a program memory references by the processor for both the instruction and the data ten

Basically I need implement program using LC3 assembly language where I can type any message using ASCII code (this will my input). Then read the output in cipher text. It has to be