-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical voting scenarios in a university setting, ensuring a diverse distribution of votes across different positions to reflect realistic election outcomes.

-- Realistic data for Voting_record
INSERT INTO Voting_record (President_Vote, Vice_President_Vote, Secretary_Vote, Treasurer_Vote, Class_President_Vote, Class_Senator_Vote) VALUES (25, 18, 22, 15, 30, 20);
INSERT INTO Voting_record (President_Vote, Vice_President_Vote, Secretary_Vote, Treasurer_Vote, Class_President_Vote, Class_Senator_Vote) VALUES (30, 25, 20, 18, 28, 22);
INSERT INTO Voting_record (President_Vote, Vice_President_Vote, Secretary_Vote, Treasurer_Vote, Class_President_Vote, Class_Senator_Vote) VALUES (20, 30, 25, 22, 18, 25);

-- Realistic data for Decision_Variables
INSERT INTO Decision_Variables (President, Vice_President, Secretary, Treasurer, Class_President, Class_Senator) VALUES (True, False, False, False, False, False);
INSERT INTO Decision_Variables (President, Vice_President, Secretary, Treasurer, Class_President, Class_Senator) VALUES (False, True, False, False, False, False);
INSERT INTO Decision_Variables (President, Vice_President, Secretary, Treasurer, Class_President, Class_Senator) VALUES (False, False, True, False, False, False);

-- Realistic data for Constraint_Bounds
INSERT INTO Constraint_Bounds (Position_Filled, Student_Position_Limit) VALUES ('sum(x[i] for all i) = 1', 'x[i] + y[i] + z[i] + w[i] + u[i] + v[i] <= 1');

