-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical banking scenarios, ensuring that the total budget and loan constraints are realistic and align with common banking practices.

-- Realistic data for customer
INSERT INTO customer (cust_ID, credit_score) VALUES (1, 720);
INSERT INTO customer (cust_ID, credit_score) VALUES (2, 680);
INSERT INTO customer (cust_ID, credit_score) VALUES (3, 750);

-- Realistic data for loan
INSERT INTO loan (loan_ID, amount, branch_ID) VALUES (101, 30000, 1);
INSERT INTO loan (loan_ID, amount, branch_ID) VALUES (102, 45000, 2);
INSERT INTO loan (loan_ID, amount, branch_ID) VALUES (103, 25000, 3);
INSERT INTO loan (loan_ID, amount, branch_ID) VALUES (104, 20000, 1);
INSERT INTO loan (loan_ID, amount, branch_ID) VALUES (105, 35000, 2);

-- Realistic data for branch_loans
INSERT INTO branch_loans (branch_ID, min_loans) VALUES (1, 120000);
INSERT INTO branch_loans (branch_ID, min_loans) VALUES (2, 150000);
INSERT INTO branch_loans (branch_ID, min_loans) VALUES (3, 100000);

