Lo scenario
A civil protection agency needs a database schema to coordinate disaster response, shelter occupancy, evacuee registration, and on-site medical assistance.
Cosa contiene questo disegno
Leggi le decisioni che ne stanno alla base.
01
Introduced a Registration join table to model the many-to-many relationship between evacuees and shelters over time.
02
Separated MedicalAssistance as its own entity to track triage, treatment, and referring medical facility independently.
03
Linked Staff and Supply directly to Shelter to reflect operational assignment and resource stocking at specific locations.
Use this structure when modeling disaster response systems that require tracking people, facilities, resources, and medical care across multiple shelters and events.