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

What are the modes in which any update tasks work, What are the modes in wh...

What are the modes in which any update tasks work? Synchronous and Asynchronous.

Explain jk flip-flop using sr flip-flop, Q. Explain 4 bit Ripple counter wi...

Q. Explain 4 bit Ripple counter with necessary diagram. Q. Explain JK Master-slave Flip-flop with block diagram and logic design. Q. Explain JK flip-flop using SR flip-flop

Explain collaboration on task and event management, What is difference betw...

What is difference between collaboration on task and event management? Web-based task management application let the user handle the multiple pieces and parts of large projects

Define the term ''turn-around'', The "turn-around" time of a user job is th...

The "turn-around" time of a user job is the? Ans. Total time taken to execute the job is called "turn around" time.

Explain about the term middleware, Explain about the term Middleware. M...

Explain about the term Middleware. Middleware is the term frequently used to explain the application or business logic present within an application server. Unfortunately, simi

Explain procedure level of parallel processing, Procedure Level Here, p...

Procedure Level Here, parallelism is obtainable in the form of parallel executable procedures. In that case, design of algorithm plays a key role. E.g. every thread in Java is

What are the steps in executing the program, What are the steps in executin...

What are the steps in executing the program? 1.Fetch 2.Decode 3.Execute 4.Store

Illustrate about object oriented development, Illustrate about object orien...

Illustrate about object oriented development object oriented development is not direct way of system development as in this approach a holistic view of application domain is co

What is the difference between awt and swt, SWT (Standard Widget Toolkit) i...

SWT (Standard Widget Toolkit) is a totally independent Graphical User Interface (GUI) toolkit from IBM. They formed it for the creation of Eclipse Integrated Development Environmen

Explain the importance of object oriented modelling, Explain the importance...

Explain the importance of Object Oriented Modelling It is important to note that wi t h the growing complexity of systems, significance of modelling techniques increases. Beca

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