-- Iteration 1 Database Schema
-- Objective: Schema changes include creating a new table for decision variables, adding a configuration parameter for total budget, and updating existing tables to align with optimization requirements.

CREATE TABLE department (
  Department_ID INTEGER,
  Ranking FLOAT,
  Budget_in_Billions FLOAT
);

CREATE TABLE decision_variables (
  Department_ID INTEGER,
  fraction_allocated FLOAT
);

