-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical school bus operations, ensuring a mix of driver experience levels and school requirements to create a realistic and challenging optimization problem.

-- Realistic data for DriverAssignments
INSERT INTO DriverAssignments (DriverID, SchoolID, Assigned) VALUES (1, 101, False);
INSERT INTO DriverAssignments (DriverID, SchoolID, Assigned) VALUES (2, 102, True);
INSERT INTO DriverAssignments (DriverID, SchoolID, Assigned) VALUES (3, 103, True);

-- Realistic data for SchoolRequirements
INSERT INTO SchoolRequirements (SchoolID, RequiredDrivers) VALUES (101, 3);
INSERT INTO SchoolRequirements (SchoolID, RequiredDrivers) VALUES (102, 4);
INSERT INTO SchoolRequirements (SchoolID, RequiredDrivers) VALUES (103, 5);

-- Realistic data for Drivers
INSERT INTO Drivers (DriverID, IsFullTime) VALUES (1, True);
INSERT INTO Drivers (DriverID, IsFullTime) VALUES (2, True);
INSERT INTO Drivers (DriverID, IsFullTime) VALUES (3, True);

-- Realistic data for ExperienceMismatch
INSERT INTO ExperienceMismatch (DriverID, SchoolID, YearsMismatch) VALUES (1, 101, 2);
INSERT INTO ExperienceMismatch (DriverID, SchoolID, YearsMismatch) VALUES (2, 102, 1);
INSERT INTO ExperienceMismatch (DriverID, SchoolID, YearsMismatch) VALUES (3, 103, 0);

