-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical operational costs and capacities for ships, ensuring a balance between cost efficiency and mission requirements.

-- Realistic data for ship
INSERT INTO ship (Ship_ID, Tonnage, cost_per_knot, cost_per_ton) VALUES (1, 1500.0, 11.0, 5.5);
INSERT INTO ship (Ship_ID, Tonnage, cost_per_knot, cost_per_ton) VALUES (2, 2500.0, 13.0, 6.0);
INSERT INTO ship (Ship_ID, Tonnage, cost_per_knot, cost_per_ton) VALUES (3, 1800.0, 12.0, 5.8);

-- Realistic data for ship_mission_assignment
INSERT INTO ship_mission_assignment (Ship_ID, Mission_ID) VALUES (1, 101);
INSERT INTO ship_mission_assignment (Ship_ID, Mission_ID) VALUES (2, 102);
INSERT INTO ship_mission_assignment (Ship_ID, Mission_ID) VALUES (3, 103);

