Database Answers Kasbah du Toubkal Hotel, Morocco

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Afghanistan Rainfall
Back to the Data Model.
The Draft Business Rules have been defined and are listed below for review by the Subject Matter Experts.
A. The Area being Modelled is :-
An Agricultural Information and Early Warning System to help Afghanistan agriculture programmes.

B. The Things of Interest, ('THINGS'), include :-
B.1 Agricultural Research Stations
B.2 Agricultural Zones
B.3 Bulletins
B.4 Districts
B.5 Farms
B.6 Offices
B.7 Villages
B.8 Watersheds
B.9 Workers, (eg Supervisors and Surveyors).

C. These THINGS are Related as follows :-
C.1 Agricultural Research Stations will issue Bulletins at regular intervals.
C.2 Every Farm is in one and only one Village.
C.3 Every Village is in one and only one Agricultural Zone.
C.4 Every Village is in one and only one Watershed.
C.5 A Worker is attached to one and only one Office.
C.6 A Worker can be associated with more than one Village Survey.
C.7 A Village Survey can involve one or many Workers.

D. Other Characteristics of these THINGS include :-
D.1 A Worker can have one and only one Worker Role, (eg Surveyor or Supervisor).

E. Sample Data includes :-
To be determined

F. Typical Enquiries include :-
F.1 How many Village Surveys have been completed this month ?
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map