-- Populate CREDTIORS table INSERT INTO CREDITORS (CREDITOR_ID, CREDITOR) VALUES (1, 'Citibank'); INSERT INTO CREDITORS (CREDITOR_ID, CREDITOR) VALUES (2, 'MBNA'); INSERT INTO CREDITORS (CREDITOR_ID, CREDITOR) VALUES (3, 'Discover'); INSERT INTO CREDITORS (CREDITOR_ID, CREDITOR) VALUES (4, 'Diners Club'); INSERT INTO CREDITORS (CREDITOR_ID, CREDITOR) VALUES (5, 'Bank of America'); INSERT INTO CREDITORS (CREDITOR_ID, CREDITOR) VALUES (6, 'Capital One'); -- Populate DEBTORS table INSERT INTO DEBTORS (DEBTOR_ID, FIRST_NAME, LAST_NAME) VALUES (1, 'John', 'Barnes'); INSERT INTO DEBTORS (DEBTOR_ID, FIRST_NAME, LAST_NAME) VALUES (2, 'Tony', 'Bernoulli'); INSERT INTO DEBTORS (DEBTOR_ID, FIRST_NAME, LAST_NAME) VALUES (3, 'Bobby', 'Sikes'); INSERT INTO DEBTORS (DEBTOR_ID, FIRST_NAME, LAST_NAME) VALUES (4, 'Jessica', 'Fox'); INSERT INTO DEBTORS (DEBTOR_ID, FIRST_NAME, LAST_NAME) VALUES (5, 'Linda', 'McHannel'); INSERT INTO DEBTORS (DEBTOR_ID, FIRST_NAME, LAST_NAME) VALUES (6, 'Brandon', 'Crane'); -- Populate DEBTS table INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT) VALUES (1, 5, 1250.44, 1949.56); INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT) VALUES (1, 6, 567.23, 3932.77); INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT) VALUES (2, 1, 0.00, 2500.00); INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT) VALUES (2, 3, 1809.87, 190.13); INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT) VALUES (3, 1, 2000.00, 0.00); INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT) VALUES (4, 4, 12.34, 587.66); INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT) VALUES (4, 5, 224.56, 775.44); INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT) VALUES (4, 1, 0.00, 4500.00); INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT) VALUES (5, 2, 1870.23, 129.77); INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT) VALUES (6, 2, 2301.10, 898.90); INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT) VALUES (6, 3, 0.00, 3400.00); commit;