-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical student schedules, engagement levels, and scholarship requirements to ensure a balanced allocation between games and sports.

-- Realistic data for EngagementScores
INSERT INTO EngagementScores (StuID, GameID, SportName, GameEngagementScore, SportEngagementScore) VALUES (1, 101, 'Basketball', 1.8, 1.5);
INSERT INTO EngagementScores (StuID, GameID, SportName, GameEngagementScore, SportEngagementScore) VALUES (2, 102, 'Soccer', 2.2, 1.8);
INSERT INTO EngagementScores (StuID, GameID, SportName, GameEngagementScore, SportEngagementScore) VALUES (3, 103, 'Tennis', 1.5, 2.0);

-- Realistic data for GameAllocation
INSERT INTO GameAllocation (StuID, GameID, HoursAllocated) VALUES (1, 101, 10.0);
INSERT INTO GameAllocation (StuID, GameID, HoursAllocated) VALUES (2, 102, 12.0);
INSERT INTO GameAllocation (StuID, GameID, HoursAllocated) VALUES (3, 103, 8.0);

-- Realistic data for SportAllocation
INSERT INTO SportAllocation (StuID, SportName, HoursAllocated) VALUES (1, 'Basketball', 8.0);
INSERT INTO SportAllocation (StuID, SportName, HoursAllocated) VALUES (2, 'Soccer', 6.0);
INSERT INTO SportAllocation (StuID, SportName, HoursAllocated) VALUES (3, 'Tennis', 10.0);

