상황
A forestry agency monitors forest health using satellite-derived NDVI; the ER diagram models plots, satellites, images, NDVI measurements, health classifications, and per-plot status history.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Separate HealthClassification as a lookup table to avoid repeating threshold ranges
02
Use PlotHealthStatus as an associative entity linking plot, measurement, and classification
03
Model SatelliteImage with foreign keys to both Satellite and ForestPlot to support many images per plot and satellite
When designing a database for remote-sensing vegetation monitoring or any time-series environmental classification system.