-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical departmental budget allocations and rankings in a mid-sized company, ensuring that the total budget constraint is respected while allowing for meaningful optimization.

-- Realistic data for department
INSERT INTO department (Department_ID, Ranking, Budget_in_Billions) VALUES (1, 1.8, 0.6);
INSERT INTO department (Department_ID, Ranking, Budget_in_Billions) VALUES (2, 2.5, 1.2);
INSERT INTO department (Department_ID, Ranking, Budget_in_Billions) VALUES (3, 3.2, 1.8);

-- Realistic data for decision_variables
INSERT INTO decision_variables (Department_ID, fraction_allocated) VALUES (1, 0.25);
INSERT INTO decision_variables (Department_ID, fraction_allocated) VALUES (2, 0.35);
INSERT INTO decision_variables (Department_ID, fraction_allocated) VALUES (3, 0.4);

