-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical airline operational costs, aircraft capabilities, and employee salary ranges to ensure a realistic and solvable optimization problem.

-- Realistic data for flight
INSERT INTO flight (flno, price, distance) VALUES (101, 5000.0, 300.0);
INSERT INTO flight (flno, price, distance) VALUES (102, 7500.0, 450.0);
INSERT INTO flight (flno, price, distance) VALUES (103, 10000.0, 600.0);

-- Realistic data for aircraft
INSERT INTO aircraft (aid, distance) VALUES (1, 500.0);
INSERT INTO aircraft (aid, distance) VALUES (2, 700.0);
INSERT INTO aircraft (aid, distance) VALUES (3, 1000.0);

-- Realistic data for employee
INSERT INTO employee (eid, salary) VALUES (10, 3000.0);
INSERT INTO employee (eid, salary) VALUES (20, 4000.0);
INSERT INTO employee (eid, salary) VALUES (30, 5000.0);

-- Realistic data for flight_assignment
INSERT INTO flight_assignment (flno, aid, eid, binary_decision) VALUES (101, 1, 10, True);
INSERT INTO flight_assignment (flno, aid, eid, binary_decision) VALUES (102, 2, 20, True);
INSERT INTO flight_assignment (flno, aid, eid, binary_decision) VALUES (103, 3, 30, True);

