-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical student budgets and restaurant costs, ensuring a variety of scenarios for optimization. Ratings were chosen to reflect a range of restaurant quality.

-- Realistic data for Restaurant
INSERT INTO Restaurant (ResID, Rating) VALUES (1, 4.5);
INSERT INTO Restaurant (ResID, Rating) VALUES (2, 3.8);
INSERT INTO Restaurant (ResID, Rating) VALUES (3, 5.0);

-- Realistic data for Student_Budget
INSERT INTO Student_Budget (StuID, Budget) VALUES (101, 120);
INSERT INTO Student_Budget (StuID, Budget) VALUES (102, 180);
INSERT INTO Student_Budget (StuID, Budget) VALUES (103, 150);

-- Realistic data for Cost_Per_Visit
INSERT INTO Cost_Per_Visit (StuID, ResID, Cost) VALUES (101, 1, 12.0);
INSERT INTO Cost_Per_Visit (StuID, ResID, Cost) VALUES (102, 2, 15.0);
INSERT INTO Cost_Per_Visit (StuID, ResID, Cost) VALUES (103, 3, 20.0);

-- Realistic data for Visits_Restaurant
INSERT INTO Visits_Restaurant (StuID, ResID, Visits) VALUES (101, 1, 3);
INSERT INTO Visits_Restaurant (StuID, ResID, Visits) VALUES (102, 2, 4);
INSERT INTO Visits_Restaurant (StuID, ResID, Visits) VALUES (103, 3, 2);

