-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical retail staffing needs and bonus structures, ensuring each shop has a realistic number of employees and bonuses reflect common retail compensation practices.

-- Realistic data for evaluation
INSERT INTO evaluation (Employee_ID, Bonus) VALUES (1, 500.0);
INSERT INTO evaluation (Employee_ID, Bonus) VALUES (2, 750.0);
INSERT INTO evaluation (Employee_ID, Bonus) VALUES (3, 1000.0);

-- Realistic data for hiring
INSERT INTO hiring (Employee_ID, Shop_ID, binary_assignment) VALUES (1, 101, True);
INSERT INTO hiring (Employee_ID, Shop_ID, binary_assignment) VALUES (2, 102, True);
INSERT INTO hiring (Employee_ID, Shop_ID, binary_assignment) VALUES (3, 103, True);

-- Realistic data for shop_requirements
INSERT INTO shop_requirements (Shop_ID, Min_Employees) VALUES (101, 3);
INSERT INTO shop_requirements (Shop_ID, Min_Employees) VALUES (102, 4);
INSERT INTO shop_requirements (Shop_ID, Min_Employees) VALUES (103, 5);

