The 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.
What is in this drawing
Read the decisions behind it.
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.
More like this