-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were chosen to reflect a realistic distribution of captain ages and ship assignments, ensuring that the optimization problem remains solvable while respecting business constraints.

-- Realistic data for Captain
INSERT INTO Captain (id, age, class) VALUES (1, 45, 'A');
INSERT INTO Captain (id, age, class) VALUES (2, 50, 'B');
INSERT INTO Captain (id, age, class) VALUES (3, 55, 'C');

-- Realistic data for CaptainShipAssignment
INSERT INTO CaptainShipAssignment (captain_id, ship_id, assignment) VALUES (1, 101, True);
INSERT INTO CaptainShipAssignment (captain_id, ship_id, assignment) VALUES (2, 102, True);
INSERT INTO CaptainShipAssignment (captain_id, ship_id, assignment) VALUES (3, 103, True);

-- Realistic data for ConstraintBounds
INSERT INTO ConstraintBounds (captain_assignment, ship_assignment) VALUES (1, 1);

