-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical swimming event sizes, swimmer capabilities, and stadium capacities to ensure a balanced and realistic optimization scenario.

-- Realistic data for PerformanceScores
INSERT INTO PerformanceScores (swimmer_id, event_id, performance_score) VALUES (1, 101, 9.5);
INSERT INTO PerformanceScores (swimmer_id, event_id, performance_score) VALUES (2, 102, 8.7);
INSERT INTO PerformanceScores (swimmer_id, event_id, performance_score) VALUES (3, 103, 9.0);

-- Realistic data for SwimmerEventAssignments
INSERT INTO SwimmerEventAssignments (swimmer_id, event_id, assignment) VALUES (1, 101, True);
INSERT INTO SwimmerEventAssignments (swimmer_id, event_id, assignment) VALUES (2, 102, True);
INSERT INTO SwimmerEventAssignments (swimmer_id, event_id, assignment) VALUES (3, 103, True);

-- Realistic data for StadiumCapacities
INSERT INTO StadiumCapacities (event_id, capacity) VALUES (101, 500);
INSERT INTO StadiumCapacities (event_id, capacity) VALUES (102, 1000);
INSERT INTO StadiumCapacities (event_id, capacity) VALUES (103, 1500);

