-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical naval battle scenarios, ensuring that ship assignments and battle requirements are realistic and align with historical data on ship deployments and battle outcomes.

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

-- Realistic data for battle_requirements
INSERT INTO battle_requirements (battle_id, min_ships) VALUES (101, 3);
INSERT INTO battle_requirements (battle_id, min_ships) VALUES (102, 5);
INSERT INTO battle_requirements (battle_id, min_ships) VALUES (103, 2);

-- Realistic data for deaths_by_ship_battle
INSERT INTO deaths_by_ship_battle (ship_id, battle_id, deaths) VALUES (1, 101, 15);
INSERT INTO deaths_by_ship_battle (ship_id, battle_id, deaths) VALUES (2, 102, 25);
INSERT INTO deaths_by_ship_battle (ship_id, battle_id, deaths) VALUES (3, 103, 5);

