-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical stadium capacities and expected attendance for concerts of varying popularity, ensuring a mix of small, medium, and large events.

-- Realistic data for concert_stadium_mapping
INSERT INTO concert_stadium_mapping (concert_ID, stadium_ID) VALUES (1, 101);
INSERT INTO concert_stadium_mapping (concert_ID, stadium_ID) VALUES (2, 102);
INSERT INTO concert_stadium_mapping (concert_ID, stadium_ID) VALUES (3, 103);

-- Realistic data for attendance_coefficients
INSERT INTO attendance_coefficients (concert_ID, stadium_ID, coefficient) VALUES (1, 101, 120.0);
INSERT INTO attendance_coefficients (concert_ID, stadium_ID, coefficient) VALUES (1, 102, 180.0);
INSERT INTO attendance_coefficients (concert_ID, stadium_ID, coefficient) VALUES (2, 102, 250.0);
INSERT INTO attendance_coefficients (concert_ID, stadium_ID, coefficient) VALUES (2, 103, 300.0);
INSERT INTO attendance_coefficients (concert_ID, stadium_ID, coefficient) VALUES (3, 103, 400.0);

-- Realistic data for stadium_capacity
INSERT INTO stadium_capacity (stadium_ID, capacity) VALUES (101, 5000);
INSERT INTO stadium_capacity (stadium_ID, capacity) VALUES (102, 10000);
INSERT INTO stadium_capacity (stadium_ID, capacity) VALUES (103, 15000);

