-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical soccer team compositions and college diversity requirements, ensuring a balance between player skill (yellow cards) and team needs (positions and college representation).

-- Realistic data for Tryout
INSERT INTO Tryout (pID, pPos, cName, yCard) VALUES (1, 'Goalkeeper', 'College A', 0);
INSERT INTO Tryout (pID, pPos, cName, yCard) VALUES (2, 'Defender', 'College B', 1);
INSERT INTO Tryout (pID, pPos, cName, yCard) VALUES (3, 'Midfielder', 'College C', 2);
INSERT INTO Tryout (pID, pPos, cName, yCard) VALUES (4, 'Forward', 'College A', 1);
INSERT INTO Tryout (pID, pPos, cName, yCard) VALUES (5, 'Defender', 'College B', 0);

-- Realistic data for PositionRequirements
INSERT INTO PositionRequirements (position, required_players) VALUES ('Goalkeeper', 1);
INSERT INTO PositionRequirements (position, required_players) VALUES ('Defender', 4);
INSERT INTO PositionRequirements (position, required_players) VALUES ('Midfielder', 4);
INSERT INTO PositionRequirements (position, required_players) VALUES ('Forward', 2);

-- Realistic data for CollegeLimits
INSERT INTO CollegeLimits (college, max_players) VALUES ('College A', 3);
INSERT INTO CollegeLimits (college, max_players) VALUES ('College B', 3);
INSERT INTO CollegeLimits (college, max_players) VALUES ('College C', 3);

-- Realistic data for PlayerYellowCards
INSERT INTO PlayerYellowCards (pID, yCard) VALUES (1, 0);
INSERT INTO PlayerYellowCards (pID, yCard) VALUES (2, 1);
INSERT INTO PlayerYellowCards (pID, yCard) VALUES (3, 2);

