-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical staffing levels and customer satisfaction scores for a small chain of coffee shops, ensuring that the optimization problem remains solvable and realistic.

-- Realistic data for shop
INSERT INTO shop (Shop_ID, Score, Num_of_staff) VALUES (1, 4.5, 5);
INSERT INTO shop (Shop_ID, Score, Num_of_staff) VALUES (2, 3.8, 8);
INSERT INTO shop (Shop_ID, Score, Num_of_staff) VALUES (3, 4.2, 6);

-- Realistic data for staff_allocation
INSERT INTO staff_allocation (HH_ID, Num_of_shaff_in_charge) VALUES (101, 3);
INSERT INTO staff_allocation (HH_ID, Num_of_shaff_in_charge) VALUES (102, 4);
INSERT INTO staff_allocation (HH_ID, Num_of_shaff_in_charge) VALUES (103, 2);

