-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical distances between major airports and realistic fee rates charged by airports. Capacities were set to reflect typical airport operations, ensuring a balance between demand and supply.

-- Realistic data for Flights
INSERT INTO Flights (flight_id, airport_id, assignment) VALUES (1, 101, True);
INSERT INTO Flights (flight_id, airport_id, assignment) VALUES (2, 102, True);
INSERT INTO Flights (flight_id, airport_id, assignment) VALUES (3, 103, True);

-- Realistic data for Airports
INSERT INTO Airports (airport_id, capacity) VALUES (101, 120);
INSERT INTO Airports (airport_id, capacity) VALUES (102, 180);
INSERT INTO Airports (airport_id, capacity) VALUES (103, 150);

-- Realistic data for Distances
INSERT INTO Distances (flight_id, airport_id, distance) VALUES (1, 101, 550.0);
INSERT INTO Distances (flight_id, airport_id, distance) VALUES (2, 102, 800.0);
INSERT INTO Distances (flight_id, airport_id, distance) VALUES (3, 103, 950.0);

-- Realistic data for FeeRates
INSERT INTO FeeRates (airport_id, fee_rate) VALUES (101, 12.0);
INSERT INTO FeeRates (airport_id, fee_rate) VALUES (102, 18.0);
INSERT INTO FeeRates (airport_id, fee_rate) VALUES (103, 22.0);

