-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical orchestra performance schedules, venue capacities, and conductor availability to ensure a realistic and solvable optimization problem.

-- Realistic data for OrchestraPerformanceLimits
INSERT INTO OrchestraPerformanceLimits (Orchestra_ID, MaxPerformances) VALUES (1, 5);
INSERT INTO OrchestraPerformanceLimits (Orchestra_ID, MaxPerformances) VALUES (2, 10);
INSERT INTO OrchestraPerformanceLimits (Orchestra_ID, MaxPerformances) VALUES (3, 15);

-- Realistic data for VenueCapacity
INSERT INTO VenueCapacity (Show_ID, Capacity) VALUES (101, 200);
INSERT INTO VenueCapacity (Show_ID, Capacity) VALUES (102, 300);
INSERT INTO VenueCapacity (Show_ID, Capacity) VALUES (103, 400);

-- Realistic data for Show
INSERT INTO Show (Show_ID, Attendance, Performances) VALUES (101, 150, 1);
INSERT INTO Show (Show_ID, Attendance, Performances) VALUES (102, 250, 2);
INSERT INTO Show (Show_ID, Attendance, Performances) VALUES (103, 350, 3);

