-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical university advisor workloads and average pet weights, ensuring that constraints are neither too tight nor too loose, allowing for a balanced distribution of students and pets.

-- Realistic data for Has_Pet
INSERT INTO Has_Pet (StuID, PetID, AdvisorID) VALUES (1, 101, 201);
INSERT INTO Has_Pet (StuID, PetID, AdvisorID) VALUES (2, 102, 202);
INSERT INTO Has_Pet (StuID, PetID, AdvisorID) VALUES (3, 103, 203);

-- Realistic data for AdvisorConstraints
INSERT INTO AdvisorConstraints (AdvisorID, MaxStudents, MaxWeight) VALUES (201, 5, 100.0);
INSERT INTO AdvisorConstraints (AdvisorID, MaxStudents, MaxWeight) VALUES (202, 6, 120.0);
INSERT INTO AdvisorConstraints (AdvisorID, MaxStudents, MaxWeight) VALUES (203, 7, 150.0);

-- Realistic data for PetWeightAssignment
INSERT INTO PetWeightAssignment (AdvisorID, TotalPetWeight) VALUES (201, 50.0);
INSERT INTO PetWeightAssignment (AdvisorID, TotalPetWeight) VALUES (202, 60.0);
INSERT INTO PetWeightAssignment (AdvisorID, TotalPetWeight) VALUES (203, 70.0);

