CSE1IS Information Systems
Assignment 2

Introduction

Fishing in the public waterbodies of Victoria (rivers, creeks, lakes and reservoirs) is controlled by the Freshwater Fisheries Section (FFS) of the Department of Conservation and Natural Resources. To fish in the waterbodies, fishermen must buy a fishing licence. Licences cost $12 per month or $29 per year. Part of the income generated from selling fishing licences is used to stock the waterbodies with fish. Fish put into the waterbodies can be rainbow trout, brown trout or redfin. The State government has asked the FFS to determine if the stocking of waterbodies around the State is successful - are fishermen catching fish? A survey form was designed to record the details of fish being caught. These forms were provided to fisherman when they bought fishing licences each year. The forms were to be filled in each year and submitted to the FFS by post. The forms were very successful as fisherman like to boast about their catches. Unfortunately the FFS hadn't thought about how they were going to process the data on the survey forms. At the moment thousands of completed survey forms are stored in boxes in the main office of the FFS.

General Requirements

Your job is to design a small information system which will help the FFS to process the survey forms quickly and accurately. An example of a completed survey form is below.

The information system you design should allow for the efficient and accurate input, storage and maintenance of data on the survey forms.

Two reports are required:

1. A summary report for a particular year for each waterbody in the State in alphabetical order. For each waterbody the three species of fish are to be listed. For each species the total number caught; the average length and weight; and the average number of hours spent per fish caught are to be displayed. At the bottom of the report should be the same statistics for the whole State for the 3 species combined plus the total number of fishermen who recorded catching fish and the total number of hours spent fishing.
2. A detail report for a particular fisherman listing each year they have recorded catching fish. Fishermen will pay $20 for this report. For each year, each waterbody fished at should be listed. For each waterbody the date, species, length and weight of each fish caught should be displayed. For each waterbody, for each year, a summary of the total number of fish caught, the total number of hours spent fishing, the average weight and length of fish and the average time spent per fish caught should be displayed. These statistics should be repeated for each year and and for the whole report.

Assumptions

Assume that a fisherman only fishes one session at one waterbody per day and a session does not go past midnight.

Assume that a fisherman always records a waterbody name and fish species correctly on a survey form. (We know that fisherman always record fish length and weight correctly!!).

NOTE: If you are not sure about any of the requirements for the information system contact your lecturer.

Specific requirements

1. An Entity Relationship diagram for the system (3 marks).
2. A database design displaying the name, data type, width, validation rules and a description for each field in each table. The description should include which fields are primary and/or foreign keys (5 marks).
3. Screen designs for the menus needed for the system (4 marks).
4. A data maintenance screen for fishing sessions and catches (5 marks).
5. Designs for the 2 reports (8 marks).

Submission requirements:

• The assignment should be firmly bound in an A4 size folder. Do NOT submit assignments in plastic sheet protectors.
• Title page:
  • Subject name
  • Assignment title
  • Student name
  • Student ID number
  • a signed Statement of Authorship
• Table of contents
• ER diagram
• Database design
• Menu design
• Data mainenance screen design
• Report designs

This page last updated on 19/08/08 by Chris Cope, La Trobe University, Bendigo