-- Problem 1a
-- INSERT INTO borrower(cname, lno)
--     VALUES 
--         ('Omega', 0),
--         ('Omega', 6)

-- Problem 1b insert new 
-- INSERT INTO loan(no, type, minCredit)
--     VALUES  
--         (23, 'dontTakeLoan', 1000)

-- problem 1d
-- INSERT INTO borrower(cname, lno)
--     VALUES
--         ('all_loan', 23)

-- problem 1f

-- INSERT INTO customer(name, credit)
--     VALUES 
--         ('same1', 999),
--         ('same2_1', 999),
--         ('same3_1', 999),
--         ('same4', 888),
--         ('same5_4', 888)

-- INSERT INTO borrower(cname, lno)
--     VALUES
--         ('same1', 3),
--         ('same1', 4),
--         ('same1', 10),
--         ('same2_1', 3),
--         ('same2_1', 4),
--         ('same2_1', 10),
--         ('same3_1', 3),
--         ('same3_1', 4),
--         ('same3_1', 10)

-- Problem 2a
-- CREATE VIEW Original_loan as (SELECT * FROM loan);

INSERT INTO customer(name, credit)
    VALUES 
        ('same1', 999),
        ('same2_1', 999),
        ('same3_1', 999)