-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical staffing needs and operational costs for museums of varying sizes, ensuring a balance between visitor satisfaction and cost efficiency.

-- Realistic data for museum
INSERT INTO museum (Num_of_Staff, satisfaction_coefficient, cost_coefficient) VALUES (8, 1.3, 0.9);
INSERT INTO museum (Num_of_Staff, satisfaction_coefficient, cost_coefficient) VALUES (12, 1.6, 1.1);
INSERT INTO museum (Num_of_Staff, satisfaction_coefficient, cost_coefficient) VALUES (6, 1.2, 0.8);

-- Realistic data for ObjectiveCoefficients
INSERT INTO ObjectiveCoefficients (museum_id, satisfaction_coefficient, cost_coefficient) VALUES (1, 1.3, 0.9);
INSERT INTO ObjectiveCoefficients (museum_id, satisfaction_coefficient, cost_coefficient) VALUES (2, 1.6, 1.1);
INSERT INTO ObjectiveCoefficients (museum_id, satisfaction_coefficient, cost_coefficient) VALUES (3, 1.2, 0.8);

-- Realistic data for ConstraintBounds
INSERT INTO ConstraintBounds (museum_id, minimum_staff_required, maximum_staff_capacity) VALUES (1, 5, 15);
INSERT INTO ConstraintBounds (museum_id, minimum_staff_required, maximum_staff_capacity) VALUES (2, 7, 20);
INSERT INTO ConstraintBounds (museum_id, minimum_staff_required, maximum_staff_capacity) VALUES (3, 4, 10);

