-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical marketing budgets and purchase data for retail chains, ensuring a balance between budget allocation and historical purchase performance.

-- Realistic data for BudgetAllocation
INSERT INTO BudgetAllocation (branch_id, amount) VALUES (1, 12000);
INSERT INTO BudgetAllocation (branch_id, amount) VALUES (2, 18000);
INSERT INTO BudgetAllocation (branch_id, amount) VALUES (3, 15000);

-- Realistic data for Purchase
INSERT INTO Purchase (branch_id, Total_pounds) VALUES (1, 60000);
INSERT INTO Purchase (branch_id, Total_pounds) VALUES (2, 90000);
INSERT INTO Purchase (branch_id, Total_pounds) VALUES (3, 80000);

