-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical business scenarios where companies have varying profit potentials and employee capacity constraints. The employee allocation was designed to ensure that the optimization problem is both challenging and solvable.

-- Realistic data for company
INSERT INTO company (Company_ID, Profits_in_Billion) VALUES (1, 1.5);
INSERT INTO company (Company_ID, Profits_in_Billion) VALUES (2, 2.0);
INSERT INTO company (Company_ID, Profits_in_Billion) VALUES (3, 3.0);

-- Realistic data for employment
INSERT INTO employment (People_ID, allocated_employees) VALUES (101, 30);
INSERT INTO employment (People_ID, allocated_employees) VALUES (102, 20);
INSERT INTO employment (People_ID, allocated_employees) VALUES (103, 10);
INSERT INTO employment (People_ID, allocated_employees) VALUES (104, 25);
INSERT INTO employment (People_ID, allocated_employees) VALUES (105, 15);

-- Realistic data for company_constraints
INSERT INTO company_constraints (Company_ID, max_employees) VALUES (1, 50);
INSERT INTO company_constraints (Company_ID, max_employees) VALUES (2, 60);
INSERT INTO company_constraints (Company_ID, max_employees) VALUES (3, 70);

