-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical industry standards for pilot flight assignments and aircraft utilization, ensuring a balance between pilot workload and aircraft capacity.

-- Realistic data for flights_assigned
INSERT INTO flights_assigned (pilot_id, aircraft_id, number_of_flights) VALUES (1, 101, 12);
INSERT INTO flights_assigned (pilot_id, aircraft_id, number_of_flights) VALUES (2, 102, 18);
INSERT INTO flights_assigned (pilot_id, aircraft_id, number_of_flights) VALUES (3, 103, 15);

-- Realistic data for pilot_constraints
INSERT INTO pilot_constraints (pilot_id, min_flights) VALUES (1, 10);
INSERT INTO pilot_constraints (pilot_id, min_flights) VALUES (2, 15);
INSERT INTO pilot_constraints (pilot_id, min_flights) VALUES (3, 12);

-- Realistic data for aircraft_constraints
INSERT INTO aircraft_constraints (aircraft_id, max_flights) VALUES (101, 120);
INSERT INTO aircraft_constraints (aircraft_id, max_flights) VALUES (102, 100);
INSERT INTO aircraft_constraints (aircraft_id, max_flights) VALUES (103, 110);

