-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical resource allocation scenarios in government agencies, considering the impact of resource allocation on casualty reduction and budget constraints.

-- Realistic data for perpetrator
INSERT INTO perpetrator (Killed, Injured) VALUES (10, 50);
INSERT INTO perpetrator (Killed, Injured) VALUES (5, 30);
INSERT INTO perpetrator (Killed, Injured) VALUES (20, 100);

-- Realistic data for ResourceAllocation
INSERT INTO ResourceAllocation (location_id, amount) VALUES (1, 500);
INSERT INTO ResourceAllocation (location_id, amount) VALUES (2, 300);
INSERT INTO ResourceAllocation (location_id, amount) VALUES (3, 700);

-- Realistic data for LocationCosts
INSERT INTO LocationCosts (location_id, cost) VALUES (1, 2000);
INSERT INTO LocationCosts (location_id, cost) VALUES (2, 1500);
INSERT INTO LocationCosts (location_id, cost) VALUES (3, 2500);

