The scenario
Design a relational schema for a satellite-based NDVI monitoring platform that tracks satellites, sensors, spectral bands, image acquisitions, NDVI computations, regional results, and user alert subscriptions.
What is in this drawing
Read the decisions behind it.
01
Use a separate SpectralBand table to link red and NIR bands to each NDVI computation
02
Track regional NDVI results per acquisition to support time-series analysis
03
Model user organizations and alert subscriptions for threshold notifications
Reusable for any remote sensing data pipeline requiring satellite, sensor, and derived vegetation index storage with user alerting.
More like this