Scenario
The Department of Wildlife is undertaking a survey of birdlife in Home County to help understand the
impact of environmental change on the wider wildlife population. 25 volunteers from the Home County
Ornithological Society will carry out the survey. Each volunteer is allocated two 1km by 1km squares of
habitat chosen by the Department of Wildlife. Each square is visited for a period of four hours in April,
June, September and December. It is the responsibility of the volunteer to ensure that they visit as much
of the allocated area as possible in the given time.
Each square is allocated a code number, HC01 to HC50, and a map of the square is provided to the
volunteer responsible for surveying it. The square is further subdivided into 100m by 100m sub-squares
to more accurately locate the species found. These sub-squares are coded 00 in the top left (North-West)
corner to 99 in bottom right (South-East) corner as follows:
00 01 02 03 04 05 06 07 08 09
10 11 12 13 14 15 16 17 18 19
20 21 22 23 24 25 26 27 28 29
30 31 32 33 34 35 36 37 38 39
40 41 42 43 44 45 46 47 48 49
50 51 52 53 54 55 56 57 58 59
60 61 62 63 64 65 66 67 68 69
70 71 72 73 74 75 76 77 78 79
80 81 82 83 84 85 86 87 88 89
90 91 92 93 94 95 96 97 98 99
When carrying out a survey the volunteers have paper sheets on which to record their observations.
The general survey data recorded is:
Volunteer name
Code number of square
Date of visit
Start time of visit
Weather conditions
Comments (to allow for any extra detail that may have a bearing on the results, e.g. a farmer
ploughing a field).
Systems Analysis & Design June 2011 Final NCC Education 2011
The data recorded for each species seen is:
Code of sub-square
Species name
Number seen
Number of young or juvenile birds seen
If the species is seen in more than one sub-square, a separate record is made for each sub-square, i.e. there
could be up to 100 records for a single species on one survey date.
Upon completing the survey the volunteers will submit their survey detail via standard forms on the
survey website. This adds the data to the survey database and will be used by experts in the Department
of Wildlife to map species distribution over the county and measure trends in bird population over time. It
is intended that the survey will continue over many years.
You are responsible for modelling and creating the system that will manage the survey.
Create a data model detailing the data structure required to support the information and process
requirements of the birdlife survey system including:
a) An Entity Relationship Diagram for the system.
b) Entity descriptions for all entities in the diagram.
c) Appropriate attributes for all entities including primary and foreign keys.
d) Relationships detailing optionality and degree of relationships between entities.
Create a data model detailing the data structure required to support the information and process
requirements of the birdlife survey system including:
a) An Entity Relationship Diagram for the system.
b) Entity descriptions for all entities in the diagram.
c) Appropriate attributes for all entities including primary and foreign keys.
d) Relationships detailing optionality and degree of relationships between entities.
Create a database design for the birdlife survey system including:
a) A set of fully normalised tables showing the normalisation process for each table.
b) Data Dictionary entries for all items included in the database design.
Create a prototype user interface for use by a volunteer including, as a minimum, the following functions:
a) Adding the general details of a new survey.
b) Viewing the data from one of their own surveys.
c) Recording the sighting of a species.
Ive already identified the Square table, Subsquare table and Species table.
square table will have attributes Squarecode,Volunteer, Weather and Comments.
SubSquare table will have attributes SubsquareCode, SpecName, DtVisited, TimeVisited.
the context diagram: volunteer and Experts as entities.
am stuck in the DFD!!! Anyone can help...please!!!!
thks
shameera
