-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical event sizes and member availability patterns in political organizations, ensuring a balance between event capacity and member effectiveness.

-- Realistic data for effectiveness_scores
INSERT INTO effectiveness_scores (member_id, event_id, efficiency_score) VALUES (1, 101, 0.85);
INSERT INTO effectiveness_scores (member_id, event_id, efficiency_score) VALUES (2, 102, 0.95);
INSERT INTO effectiveness_scores (member_id, event_id, efficiency_score) VALUES (3, 103, 0.75);

-- Realistic data for member_availability
INSERT INTO member_availability (member_id, event_id, is_available) VALUES (1, 101, True);
INSERT INTO member_availability (member_id, event_id, is_available) VALUES (2, 102, False);
INSERT INTO member_availability (member_id, event_id, is_available) VALUES (3, 103, True);

-- Realistic data for party_events
INSERT INTO party_events (event_id, Member_in_charge_ID, max_members_per_event) VALUES (101, 1, 50);
INSERT INTO party_events (event_id, Member_in_charge_ID, max_members_per_event) VALUES (102, 2, 100);
INSERT INTO party_events (event_id, Member_in_charge_ID, max_members_per_event) VALUES (103, 3, 150);

-- Realistic data for member_event_assignments
INSERT INTO member_event_assignments (member_id, event_id, assignment) VALUES (1, 101, True);
INSERT INTO member_event_assignments (member_id, event_id, assignment) VALUES (2, 102, False);
INSERT INTO member_event_assignments (member_id, event_id, assignment) VALUES (3, 103, True);

