El escenario
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.
Qué hay en este dibujo
Lee las decisiones que hay detrás.
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.