-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical resource allocation scenarios in university sports, ensuring that constraints are neither too tight nor too loose, allowing for meaningful optimization.

-- Realistic data for basketball_match
INSERT INTO basketball_match (All_Games_Percent, Resource_Allocation) VALUES (0.75, 110);
INSERT INTO basketball_match (All_Games_Percent, Resource_Allocation) VALUES (0.6, 140);
INSERT INTO basketball_match (All_Games_Percent, Resource_Allocation) VALUES (0.85, 130);

-- Realistic data for resource_allocation
INSERT INTO resource_allocation (Team_ID, amount) VALUES (1, 110);
INSERT INTO resource_allocation (Team_ID, amount) VALUES (2, 140);
INSERT INTO resource_allocation (Team_ID, amount) VALUES (3, 130);

-- Realistic data for resource_constraints
INSERT INTO resource_constraints (Team_ID, Minimum_Allocation, Maximum_Allocation) VALUES (1, 50, 200);
INSERT INTO resource_constraints (Team_ID, Minimum_Allocation, Maximum_Allocation) VALUES (2, 60, 180);
INSERT INTO resource_constraints (Team_ID, Minimum_Allocation, Maximum_Allocation) VALUES (3, 70, 190);

