-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for missing constraint bounds and updating existing tables to improve mapping adequacy. Configuration logic is updated to include scalar parameters for constraints.

CREATE TABLE customer (
  cust_ID INTEGER,
  credit_score FLOAT
);

CREATE TABLE loan (
  loan_ID INTEGER,
  amount FLOAT,
  branch_ID INTEGER
);

CREATE TABLE branch_loans (
  branch_ID INTEGER,
  min_loans FLOAT
);

