fisherpersons are not over-fishing, Computer Engineering

Assignment Help:

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


Related Discussions:- fisherpersons are not over-fishing

How do you debug a loadrunner script, VuGen have two options to help debug ...

VuGen have two options to help debug Vuser scripts-the Run Step by Step command and breakpoints. The Debug settings in the Options dialog box permit us to verify the extent of the

Explain about olap, OLAP is called as online analytical processing which gi...

OLAP is called as online analytical processing which gives answers to queries which are multi dimensional in nature. It composes relational reporting and data mining for giving sol

Wireless Networking, Suppose you work in a network security company, and yo...

Suppose you work in a network security company, and you need to prepare a survey report of a particular security issue of wireless networking. To start with, select an area of wire

Show basic concepts of permutation, Q. Show Basic concepts of permutation? ...

Q. Show Basic concepts of permutation? Let us look at the basic concepts of permutation with respect to interconnection network.  Let us say the network has set of n input node

NETWORK ADMIN, Discuss the risks of having a single root user and how more ...

Discuss the risks of having a single root user and how more limited management abilities can be given to others users on Linux/UNIX systems.uestion #Minimum 100 words accepted#

Explain indirect cycle in control unit, Q. Explain Indirect Cycle in contro...

Q. Explain Indirect Cycle in control unit? Once an instruction is fetched the subsequent step is to fetch the operands. The instruction may have indirect and direct addressing

Octave project, i need help with an octave program

i need help with an octave program

Database system, What are the three data anomalise that are likely to occur...

What are the three data anomalise that are likely to occur as a result of data redundancy?

What is the main difference between asp and asp.net, What is the Main diffe...

What is the Main difference between ASP and ASP.NET ?   ASP contains scripts which are not compiled while in ASP.net the code is compiled.

Can link and association applied interchangeably, No, You cannot apply the ...

No, You cannot apply the link and Association interchangeably. Since link is used show the relationship among the two objects. But Association is used signify the relationship

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd