O cenário
A civil protection agency needs a database schema to coordinate disaster response, shelter occupancy, evacuee registration, and on-site medical assistance.
O que há neste desenho
Entenda as decisões por trás dele.
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.