O cenário
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.
O que há neste desenho
Entenda as decisões por trás dele.
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.