情境
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.