The scenario
An agricultural extension program needs a database to record field visits by officers, crop observations made during those visits, and the resulting recommendations to farmers.
What is in this drawing
Read the decisions behind it.
01
Modeled extension officers, farmers, farms, field visits, crops, crop observations, and recommendations as separate entities.
02
Used many-to-one relationships for officer assignment, farm ownership, visit linkage, observation recording, and recommendation response.
03
Included crop scientific names and observation health/pest fields to support detailed agronomic analysis.
Reusable for any agricultural field reporting system that logs visits, observations, and expert recommendations for farms and crops.
More like this