The scenario
A civil protection agency needs a database schema to coordinate disaster response, shelter occupancy, evacuee registration, and on-site medical assistance.
What is in this drawing
Read the decisions behind it.
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.
More like this