-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical train station operations, ensuring a balance between demand, platform availability, and service compatibility.

-- Realistic data for station
INSERT INTO station (Station_ID, Total_Passengers, Number_of_Platforms) VALUES (1, 1200, 3);
INSERT INTO station (Station_ID, Total_Passengers, Number_of_Platforms) VALUES (2, 1800, 4);
INSERT INTO station (Station_ID, Total_Passengers, Number_of_Platforms) VALUES (3, 2200, 5);

-- Realistic data for train_station
INSERT INTO train_station (Train_ID, Station_ID, Service_Compatible) VALUES (101, 1, True);
INSERT INTO train_station (Train_ID, Station_ID, Service_Compatible) VALUES (102, 2, True);
INSERT INTO train_station (Train_ID, Station_ID, Service_Compatible) VALUES (103, 3, False);
INSERT INTO train_station (Train_ID, Station_ID, Service_Compatible) VALUES (101, 2, True);
INSERT INTO train_station (Train_ID, Station_ID, Service_Compatible) VALUES (102, 3, True);

-- Realistic data for service_compatibility
INSERT INTO service_compatibility (Train_ID, Station_ID, Compatible) VALUES (101, 1, True);
INSERT INTO service_compatibility (Train_ID, Station_ID, Compatible) VALUES (102, 2, True);
INSERT INTO service_compatibility (Train_ID, Station_ID, Compatible) VALUES (103, 3, False);
INSERT INTO service_compatibility (Train_ID, Station_ID, Compatible) VALUES (101, 2, True);
INSERT INTO service_compatibility (Train_ID, Station_ID, Compatible) VALUES (102, 3, True);

-- Realistic data for passenger_demand
INSERT INTO passenger_demand (Train_ID, Station_ID, Demand) VALUES (101, 1, 250);
INSERT INTO passenger_demand (Train_ID, Station_ID, Demand) VALUES (102, 2, 350);
INSERT INTO passenger_demand (Train_ID, Station_ID, Demand) VALUES (103, 3, 150);
INSERT INTO passenger_demand (Train_ID, Station_ID, Demand) VALUES (101, 2, 300);
INSERT INTO passenger_demand (Train_ID, Station_ID, Demand) VALUES (102, 3, 400);

