السيناريو
Design a relational schema for a civil protection management system tracking emergency calls, resulting incidents, dispatch orders, response teams, team members, and allocated resources.
ما الذي يتضمنه هذا الرسم
اقرأ القرارات الكامنة وراءه.
01
Model call intake as many-to-one to incident to allow multiple calls reporting the same incident.
02
Separate dispatch orders from response teams to support multiple dispatches per incident and team reassignment.
03
Track team members with a foreign key to response team and resources with a foreign key to dispatch.
Use this pattern when building a database for emergency response coordination, incident management, or dispatching systems that need clear relationships among calls, incidents, teams, and resources.