-- Iteration 1 Database Schema
-- Objective: Schema changes include creating a new table for decision variables and updating the business configuration logic to include total available resources as a scalar parameter. Adjustments ensure all optimization requirements are mapped and business logic is preserved.

CREATE TABLE storm (
  Damage_millions_USD FLOAT,
  Max_speed FLOAT
);

CREATE TABLE affected_region (
  Number_city_affected INTEGER
);

CREATE TABLE resource_allocation (
  resources_allocated FLOAT
);

