-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical stadium capacities, average attendance figures, and realistic injury risks in sports leagues. The approach ensures that the optimization problem is both meaningful and solvable by balancing attendance and injury risk.

-- Realistic data for stadium
INSERT INTO stadium (Average_Attendance, Capacity_Percentage, Home_Games) VALUES (8000, 0.85, 6);
INSERT INTO stadium (Average_Attendance, Capacity_Percentage, Home_Games) VALUES (12000, 0.9, 8);
INSERT INTO stadium (Average_Attendance, Capacity_Percentage, Home_Games) VALUES (15000, 0.95, 6);

-- Realistic data for injury_risk
INSERT INTO injury_risk (Risk) VALUES (0.02);
INSERT INTO injury_risk (Risk) VALUES (0.03);
INSERT INTO injury_risk (Risk) VALUES (0.04);
INSERT INTO injury_risk (Risk) VALUES (0.01);
INSERT INTO injury_risk (Risk) VALUES (0.05);

-- Realistic data for game_schedule
INSERT INTO game_schedule (Scheduled) VALUES (True);
INSERT INTO game_schedule (Scheduled) VALUES (False);
INSERT INTO game_schedule (Scheduled) VALUES (True);
INSERT INTO game_schedule (Scheduled) VALUES (False);
INSERT INTO game_schedule (Scheduled) VALUES (True);

