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




Related Discussions:- fisherpersons are not over-fishing

Programming , Adavantages and disadvantages of compilers and interpreters

Adavantages and disadvantages of compilers and interpreters

What is dynamic random access memory, Q. What is Dynamic Random Access Memo...

Q. What is Dynamic Random Access Memory? RAM technology is divided into 2 technologies: Static and dynamic. A dynamic RAM (DRAM) is made with cells which store data as charge o

Enumerate the process of dynamic modelling:, Define the Process of dynamic ...

Define the Process of dynamic modelling: Analyse applicability of actions Recognize object states Create dynamic model diagram Express every state in terms o

Minimis logic function using K-map, Minimise the logic function F (A, B, C,...

Minimise the logic function F (A, B, C, D) = Π M (1, 2, 3, 8, 9, 10, 11,14) ⋅ d (7, 15) Use Karnaugh map.   Ans. Given function F=∏M(1,2,3,8,9,10,11,14).d(7, 15) F'=B'D+B'C+AC+AB'

Definitions of the procedures cons, Show that we can represent pairs of non...

Show that we can represent pairs of nonnegative integers using only numbers and arithmetic operations if we represent the pair a and b as the integer that is the product 2a3b. Give

-bit comparator using combinational logic, Design a 4-bit comparator using ...

Design a 4-bit comparator using combinational logic, and Karnaugh Maps. The inputs of the circuit are two 2-bit numbers. a) Construct the truth table given 2-bits inputs A and B, a

Programming in c, Write a program to find the area under the curve y = f(x)...

Write a program to find the area under the curve y = f(x) between x = a and x = b, integrate y = f(x) between the limits of a and b. The area under a curve between two points can b

Fail-first - artificial intelligence, Fail-first - artificial intelligence:...

Fail-first - artificial intelligence: Alternatively one such dynamic ordering procedure is known like "fail-first forward checking". In fact the idea is to take advantage of i

Why is fragmentation needed on internet not on a typical wan, Why is fragme...

Why is fragmentation needed on Internet not on a typical WAN? TCP/IP protocol utilizes the name IP datagram to demote to an Internet packet. The amount of data carried into a d

What is core dump, Raises when accessing an unassigned memory location acce...

Raises when accessing an unassigned memory location accessing a null pointer

Write Your Message!

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