-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical university club sizes and student preferences, ensuring a diverse range of preference scores and club capacities to create a meaningful optimization problem.

-- Realistic data for PreferenceScores
INSERT INTO PreferenceScores (StuID, ClubID, preference_score) VALUES (1, 101, 8);
INSERT INTO PreferenceScores (StuID, ClubID, preference_score) VALUES (1, 102, 3);
INSERT INTO PreferenceScores (StuID, ClubID, preference_score) VALUES (2, 101, 5);
INSERT INTO PreferenceScores (StuID, ClubID, preference_score) VALUES (2, 103, 7);
INSERT INTO PreferenceScores (StuID, ClubID, preference_score) VALUES (3, 102, 6);
INSERT INTO PreferenceScores (StuID, ClubID, preference_score) VALUES (3, 103, 4);

-- Realistic data for ClubCapacities
INSERT INTO ClubCapacities (ClubID, capacity) VALUES (101, 60);
INSERT INTO ClubCapacities (ClubID, capacity) VALUES (102, 40);
INSERT INTO ClubCapacities (ClubID, capacity) VALUES (103, 50);

-- Realistic data for StudentClubAssignments
INSERT INTO StudentClubAssignments (StuID, ClubID, assignment) VALUES (1, 101, True);
INSERT INTO StudentClubAssignments (StuID, ClubID, assignment) VALUES (2, 103, True);
INSERT INTO StudentClubAssignments (StuID, ClubID, assignment) VALUES (3, 102, True);

