The scenario
Design a relational database to track drone fleets, flight missions over crop fields, captured NDVI imagery, derived analysis results, and actionable prescriptions.
What is in this drawing
Read the decisions behind it.
01
Separate Flight and NDVIImage to support multiple images per flight
02
Link AnalysisResult to both image and field for spatial context
03
Store prescription against analysis and field for actionable output
Use when building a data model for drone-based crop health monitoring, vegetation index analysis, and precision agriculture workflows.
More like this