use sample1
INSERT INTO dbo.[customer] (customer_id, customer_name, customer_street, customer_city)
VALUES ('192-83-7465', 'Johnson', '12 Alma st.', 'Palo Alto' );
INSERT INTO dbo.customer (customer_id, customer_name, customer_street, customer_city)
VALUES ('677-89-9011', 'Hayes', '3 Main st.', 'Harrison' );
INSERT INTO dbo.customer (customer_id, customer_name, customer_street, customer_city)
VALUES ('182-73-6091', 'Turner', '123 Putnam st.', 'Stanford' );
INSERT INTO dbo.customer (customer_id, customer_name, customer_street, customer_city)
VALUES ('321-12-3123', 'Jones', '100 Main st.', 'Harrison' );
INSERT INTO dbo.customer (customer_id, customer_name, customer_street, customer_city)
VALUES ('336-66-9999', 'Lindsay', '175 Park Ave.', 'Pittsfield' );
INSERT INTO dbo.customer (customer_id, customer_name, customer_street, customer_city)
VALUES ('019-28-3746', 'Smith', '72 North st.', 'Rye' );




INSERT INTO dbo.account (account_number, balance)
VALUES ('A-101', 500 );
INSERT INTO dbo.account (account_number, balance)
VALUES ('A-215', 700 );
INSERT INTO dbo.account (account_number, balance)
VALUES ('A-102', 400 );
INSERT INTO dbo.account (account_number, balance)
VALUES ('A-305', 350 );
INSERT INTO dbo.account (account_number, balance)
VALUES ('A-201', 900 );
INSERT INTO dbo.account (account_number, balance)
VALUES ('A-217', 750 );
INSERT INTO dbo.account (account_number, balance)
VALUES ('A-222', 700 );



INSERT INTO dbo.depositor (customer_id, account_number)
VALUES ('192-83-7465', 'A-101' );
INSERT INTO dbo.depositor (customer_id, account_number)
VALUES ('192-83-7465', 'A-201' );
INSERT INTO dbo.depositor (customer_id, account_number)
VALUES ('019-28-3746', 'A-215' );
INSERT INTO dbo.depositor (customer_id, account_number)
VALUES ('677-89-9011', 'A-102' );
INSERT INTO dbo.depositor (customer_id, account_number)
VALUES ('182-73-6091', 'A-305' );
INSERT INTO dbo.depositor (customer_id, account_number)
VALUES ('321-12-3123', 'A-217' );
INSERT INTO dbo.depositor (customer_id, account_number)
VALUES ('336-66-9999', 'A-222' );
INSERT INTO dbo.depositor (customer_id, account_number)
VALUES ('019-28-3746', 'A-201' );
