-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical theater company operations, considering member availability, performance attendance limits, and realistic performance schedules.

-- Realistic data for member_attendance
INSERT INTO member_attendance (Member_ID, Performance_ID, Num_of_Pieces) VALUES (1, 101, 2);
INSERT INTO member_attendance (Member_ID, Performance_ID, Num_of_Pieces) VALUES (2, 102, 1);
INSERT INTO member_attendance (Member_ID, Performance_ID, Num_of_Pieces) VALUES (3, 103, 3);

-- Realistic data for performance
INSERT INTO performance (Performance_ID, Attendance) VALUES (101, 50);
INSERT INTO performance (Performance_ID, Attendance) VALUES (102, 60);
INSERT INTO performance (Performance_ID, Attendance) VALUES (103, 70);

-- Realistic data for member_availability
INSERT INTO member_availability (Member_ID, Availability) VALUES (1, 5);
INSERT INTO member_availability (Member_ID, Availability) VALUES (2, 10);
INSERT INTO member_availability (Member_ID, Availability) VALUES (3, 15);

