Lecture/데이터베이스/2006/데이터 입력

BEGIN;
 
INSERT INTO branch VALUES('Brighton', 'Brooklyn', 7100000);
INSERT INTO branch VALUES('Downtown', 'Brooklyn', 9000000);
INSERT INTO branch VALUES('Mianus', 'Horseneck', 400000);
INSERT INTO branch VALUES('North Town', 'Rye', 3700000);
INSERT INTO branch VALUES('Perryridge', 'Horseneck', 1700000);
INSERT INTO branch VALUES('Pownal', 'Bennington', 300000);
INSERT INTO branch VALUES('Redwood', 'Palo Alto', 2100000);
INSERT INTO branch VALUES('Round Hill', 'Horseneck', 8000000);
 
INSERT INTO depositor VALUES ('Hayes', 'A-102');
INSERT INTO depositor VALUES ('Johnson', 'A-101');
INSERT INTO depositor VALUES ('Johnson', 'A-201');
INSERT INTO depositor VALUES ('Jones', 'A-217');
INSERT INTO depositor VALUES ('Lindsay', 'A-222');
INSERT INTO depositor VALUES ('Smith', 'A-215');
INSERT INTO depositor VALUES ('Turner', 'A-305');
 
INSERT INTO customer VALUES('Adams', 'Spring', 'Pittsfield');
INSERT INTO customer VALUES('Brooks', 'Senator', 'Brooklyn');
INSERT INTO customer VALUES('Curry', 'North', 'Rye');
INSERT INTO customer VALUES('Glenn', 'Sand Hill', 'Woodside');
INSERT INTO customer VALUES('Green', 'Walnut', 'Stamford');
INSERT INTO customer VALUES('Hayes', 'Main', 'Harrison');
INSERT INTO customer VALUES('Johnson', 'Alma', 'Palo Alto');
INSERT INTO customer VALUES('Jones', 'MAIN', 'Harrison');
INSERT INTO customer VALUES('Lindsay', 'Park', 'Pittsfield');
INSERT INTO customer VALUES('Smith', 'North', 'Rye');
INSERT INTO customer VALUES('Turner', 'Puthnam', 'Stamford');
INSERT INTO customer VALUES('Williams', 'Nassau', 'Princeton');
 
INSERT INTO loan VALUES('L-11', 'Round Hill', 900);
INSERT INTO loan VALUES('L-14', 'Downtown', 1500);
INSERT INTO loan VALUES('L-15', 'Perryridge', 1500);
INSERT INTO loan VALUES('L-16', 'Perryridge', 1300);
INSERT INTO loan VALUES('L-17', 'Downtown', 1000);
INSERT INTO loan VALUES('L-23', 'Redwood', 2000);
INSERT INTO loan VALUES('L-93', 'Mianus', 500);
 
INSERT INTO borrower VALUES('Adams', 'L-16');
INSERT INTO borrower VALUES('Curry', 'L-93');
INSERT INTO borrower VALUES('Hayes', 'L-15');
INSERT INTO borrower VALUES('Jackson', 'L-14');
INSERT INTO borrower VALUES('Jones', 'L-17');
INSERT INTO borrower VALUES('Smith', 'L-11');
INSERT INTO borrower VALUES('Smith', 'L-23');
INSERT INTO borrower VALUES('Williams', 'L-17');
 
COMMIT;