-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical market values, sales, profits, and asset distributions for medium-sized gas companies. The approach ensures that the constraints are neither too tight nor too loose, allowing for a meaningful optimization problem.

-- Realistic data for company
INSERT INTO company (Company_ID, Market_Value) VALUES (1, 12.5);
INSERT INTO company (Company_ID, Market_Value) VALUES (2, 18.0);
INSERT INTO company (Company_ID, Market_Value) VALUES (3, 14.0);

-- Realistic data for station_company
INSERT INTO station_company (Station_ID, Company_ID) VALUES (101, 1);
INSERT INTO station_company (Station_ID, Company_ID) VALUES (102, 2);
INSERT INTO station_company (Station_ID, Company_ID) VALUES (103, 3);
INSERT INTO station_company (Station_ID, Company_ID) VALUES (104, 1);
INSERT INTO station_company (Station_ID, Company_ID) VALUES (105, 2);

-- Realistic data for constraint_bounds
INSERT INTO constraint_bounds (Constraint_Name, Bound_Value) VALUES ('Total_Sales_Limit', 120.0);
INSERT INTO constraint_bounds (Constraint_Name, Bound_Value) VALUES ('Minimum_Profits_Requirement', 60.0);
INSERT INTO constraint_bounds (Constraint_Name, Bound_Value) VALUES ('Total_Assets_Limit', 250.0);

