-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical logistics scenarios, ensuring that transportation costs, city demands, and capacities are realistic and align with the total available goods.

-- Realistic data for TransportationCosts
INSERT INTO TransportationCosts (city_id, cost_per_unit) VALUES (1, 5.0);
INSERT INTO TransportationCosts (city_id, cost_per_unit) VALUES (2, 10.0);
INSERT INTO TransportationCosts (city_id, cost_per_unit) VALUES (3, 15.0);

-- Realistic data for CityCapacities
INSERT INTO CityCapacities (city_id, max_capacity) VALUES (1, 100);
INSERT INTO CityCapacities (city_id, max_capacity) VALUES (2, 200);
INSERT INTO CityCapacities (city_id, max_capacity) VALUES (3, 300);

-- Realistic data for City
INSERT INTO City (city_id, city_demand) VALUES (1, 50);
INSERT INTO City (city_id, city_demand) VALUES (2, 150);
INSERT INTO City (city_id, city_demand) VALUES (3, 250);

-- Realistic data for QuantityShipped
INSERT INTO QuantityShipped (city_id, quantity) VALUES (1, 60.0);
INSERT INTO QuantityShipped (city_id, quantity) VALUES (2, 150.0);
INSERT INTO QuantityShipped (city_id, quantity) VALUES (3, 290.0);

