-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical cinema operations, considering average cinema capacities, typical pricing strategies, and realistic scheduling constraints.

-- Realistic data for cinema
INSERT INTO cinema (Cinema_ID, Capacity, Max_Screenings_Per_Day) VALUES (1, 120, 5);
INSERT INTO cinema (Cinema_ID, Capacity, Max_Screenings_Per_Day) VALUES (2, 180, 6);
INSERT INTO cinema (Cinema_ID, Capacity, Max_Screenings_Per_Day) VALUES (3, 250, 7);

-- Realistic data for film_schedule
INSERT INTO film_schedule (Cinema_ID_Film_ID, Show_Times) VALUES (101, 3);
INSERT INTO film_schedule (Cinema_ID_Film_ID, Show_Times) VALUES (102, 4);
INSERT INTO film_schedule (Cinema_ID_Film_ID, Show_Times) VALUES (103, 2);

-- Realistic data for film_pricing
INSERT INTO film_pricing (Cinema_ID_Film_ID, Price) VALUES (101, 12.0);
INSERT INTO film_pricing (Cinema_ID_Film_ID, Price) VALUES (102, 15.0);
INSERT INTO film_pricing (Cinema_ID_Film_ID, Price) VALUES (103, 10.0);

