-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical real estate market conditions, ensuring a mix of property types and features to reflect realistic scenarios. Prices and features were chosen to create a diverse portfolio that aligns with the constraints and objectives of the optimization problem.

-- Realistic data for Properties
INSERT INTO Properties (agreed_selling_price, vendor_requested_price, room_count, apt_feature_1) VALUES (120000.0, 110000.0, 3, 'desired_feature');
INSERT INTO Properties (agreed_selling_price, vendor_requested_price, room_count, apt_feature_1) VALUES (180000.0, 170000.0, 4, 'other_feature');
INSERT INTO Properties (agreed_selling_price, vendor_requested_price, room_count, apt_feature_1) VALUES (250000.0, 240000.0, 5, 'desired_feature');
INSERT INTO Properties (agreed_selling_price, vendor_requested_price, room_count, apt_feature_1) VALUES (95000.0, 90000.0, 2, 'desired_feature');
INSERT INTO Properties (agreed_selling_price, vendor_requested_price, room_count, apt_feature_1) VALUES (130000.0, 125000.0, 3, 'other_feature');

-- Realistic data for DecisionVariables
INSERT INTO DecisionVariables (property_id, selected) VALUES (1, True);
INSERT INTO DecisionVariables (property_id, selected) VALUES (2, False);
INSERT INTO DecisionVariables (property_id, selected) VALUES (3, True);
INSERT INTO DecisionVariables (property_id, selected) VALUES (4, True);
INSERT INTO DecisionVariables (property_id, selected) VALUES (5, False);

-- Realistic data for ConstraintBounds
INSERT INTO ConstraintBounds (constraint_name, bound_value) VALUES ('max_properties_to_sell', 3);
INSERT INTO ConstraintBounds (constraint_name, bound_value) VALUES ('max_total_rooms', 12);
INSERT INTO ConstraintBounds (constraint_name, bound_value) VALUES ('min_desired_features', 2);

