Lo scenario
Design a relational schema for an NDVI data management system that integrates satellite imagery, derived vegetation indices, ground climate observations, and research project boundaries.
Cosa contiene questo disegno
Leggi le decisioni che ne stanno alla base.
01
Modeled satellite, sensor, image, and NDVI measurement as separate entities to preserve data lineage.
02
Linked images to study areas with a foreign key to support area-specific NDVI analysis.
03
Used composite primary key in ProjectArea to represent many-to-many project-area assignments.
Reusable for any remote sensing data management ERD that links imagery products, ground truth, and research projects.