상황
A wildlife conservation organization needs a relational database to record ranger patrols, wildlife observations, and field incidents, linking each report to the responsible ranger, patrol, location, and species.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Use a separate Patrol entity to group observations and incidents per field outing.
02
Model both Observation and Incident as distinct entities with shared location and patrol foreign keys.
03
Reference Species and Location through many-to-one relationships from Observation and Incident.
This schema applies to field data collection systems in ecology, forestry, or park management where patrol teams record wildlife sightings and adverse events.