-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on historical storm data and typical resource allocation scenarios in disaster management. The approach ensures that the data reflects realistic storm impacts and resource constraints.

-- Realistic data for storm
INSERT INTO storm (Damage_millions_USD, Max_speed) VALUES (12.0, 110.0);
INSERT INTO storm (Damage_millions_USD, Max_speed) VALUES (25.0, 140.0);
INSERT INTO storm (Damage_millions_USD, Max_speed) VALUES (18.0, 130.0);

-- Realistic data for affected_region
INSERT INTO affected_region (Number_city_affected) VALUES (4);
INSERT INTO affected_region (Number_city_affected) VALUES (6);
INSERT INTO affected_region (Number_city_affected) VALUES (5);

-- Realistic data for resource_allocation
INSERT INTO resource_allocation (resources_allocated) VALUES (150.0);
INSERT INTO resource_allocation (resources_allocated) VALUES (250.0);
INSERT INTO resource_allocation (resources_allocated) VALUES (200.0);

