シナリオ
Design a relational schema for an NDVI data management system that integrates satellite imagery, derived vegetation indices, ground climate observations, and research project boundaries.
この図に含まれるもの
図の背後にある意思決定を読み解く。
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.