-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical urban bike-sharing systems, considering average station sizes, expected demand patterns, and penalty costs that reflect operational priorities.

-- Realistic data for station
INSERT INTO station (station_id, dock_count, shortage, excess) VALUES (1, 15, 0, 2);
INSERT INTO station (station_id, dock_count, shortage, excess) VALUES (2, 20, 1, 0);
INSERT INTO station (station_id, dock_count, shortage, excess) VALUES (3, 10, 0, 1);

-- Realistic data for expected_demand
INSERT INTO expected_demand (station_id, expected_demand) VALUES (1, 12);
INSERT INTO expected_demand (station_id, expected_demand) VALUES (2, 18);
INSERT INTO expected_demand (station_id, expected_demand) VALUES (3, 8);

