-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical project hours and realistic minimum assignment constraints to ensure a balanced workload among scientists and projects.

-- Realistic data for Projects
INSERT INTO Projects (ProjectID, Hours) VALUES (1, 15.0);
INSERT INTO Projects (ProjectID, Hours) VALUES (2, 25.0);
INSERT INTO Projects (ProjectID, Hours) VALUES (3, 35.0);

-- Realistic data for AssignedTo
INSERT INTO AssignedTo (ScientistID, ProjectID, binary_column) VALUES (101, 1, True);
INSERT INTO AssignedTo (ScientistID, ProjectID, binary_column) VALUES (101, 2, True);
INSERT INTO AssignedTo (ScientistID, ProjectID, binary_column) VALUES (102, 2, True);
INSERT INTO AssignedTo (ScientistID, ProjectID, binary_column) VALUES (102, 3, True);
INSERT INTO AssignedTo (ScientistID, ProjectID, binary_column) VALUES (103, 3, True);

-- Realistic data for ConstraintBounds
INSERT INTO ConstraintBounds (ConstraintType, MinAssignments) VALUES ('scientist', 2);
INSERT INTO ConstraintBounds (ConstraintType, MinAssignments) VALUES ('project', 1);

