-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical school team sizes and age distributions, ensuring that constraints are realistic and the optimization problem is solvable.

-- Realistic data for PlayerPerformance
INSERT INTO PlayerPerformance (player_id, performance_coefficient, age) VALUES (1, 1.8, 16);
INSERT INTO PlayerPerformance (player_id, performance_coefficient, age) VALUES (2, 2.3, 17);
INSERT INTO PlayerPerformance (player_id, performance_coefficient, age) VALUES (3, 2.7, 18);

-- Realistic data for TeamConstraints
INSERT INTO TeamConstraints (team_id, max_team_size, max_age_limit) VALUES (1, 15, 100);
INSERT INTO TeamConstraints (team_id, max_team_size, max_age_limit) VALUES (2, 18, 110);
INSERT INTO TeamConstraints (team_id, max_team_size, max_age_limit) VALUES (3, 20, 120);

-- Realistic data for PlayerAssignment
INSERT INTO PlayerAssignment (player_id, team_id, assignment) VALUES (1, 1, True);
INSERT INTO PlayerAssignment (player_id, team_id, assignment) VALUES (2, 2, True);
INSERT INTO PlayerAssignment (player_id, team_id, assignment) VALUES (3, 3, True);

-- Realistic data for PlayerAge
INSERT INTO PlayerAge (player_id, age) VALUES (1, 16);
INSERT INTO PlayerAge (player_id, age) VALUES (2, 17);
INSERT INTO PlayerAge (player_id, age) VALUES (3, 18);

