-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical university dormitory capacities, common allergy considerations, and realistic penalty values to ensure a meaningful optimization problem.

-- Realistic data for dormitory_capacity
INSERT INTO dormitory_capacity (dormitory_id, capacity) VALUES (1, 50);
INSERT INTO dormitory_capacity (dormitory_id, capacity) VALUES (2, 100);
INSERT INTO dormitory_capacity (dormitory_id, capacity) VALUES (3, 150);

-- Realistic data for dormitory_allergy_friendly
INSERT INTO dormitory_allergy_friendly (dormitory_id, is_allergy_friendly) VALUES (1, True);
INSERT INTO dormitory_allergy_friendly (dormitory_id, is_allergy_friendly) VALUES (2, False);
INSERT INTO dormitory_allergy_friendly (dormitory_id, is_allergy_friendly) VALUES (3, True);

-- Realistic data for allergy_penalty
INSERT INTO allergy_penalty (student_id, dormitory_id, penalty_value) VALUES (101, 2, 20.0);
INSERT INTO allergy_penalty (student_id, dormitory_id, penalty_value) VALUES (102, 2, 25.0);
INSERT INTO allergy_penalty (student_id, dormitory_id, penalty_value) VALUES (103, 2, 15.0);

-- Realistic data for student_dormitory_assignment
INSERT INTO student_dormitory_assignment (student_id, dormitory_id, assignment) VALUES (101, 1, True);
INSERT INTO student_dormitory_assignment (student_id, dormitory_id, assignment) VALUES (102, 3, True);
INSERT INTO student_dormitory_assignment (student_id, dormitory_id, assignment) VALUES (103, 2, False);

