DBMS PRACTICAL 1 TABLES

CREATE TABLE DEPOSIT (ACTNO INT, CNAME VARCHAR(50), BNAME VARCHAR(50), AMOUNT DECIMAL(8,2), ADATE DATE);

CREATE TABLE BORROW (LOANNO INT, CNAME VARCHAR(50), BNAME VARCHAR(50), AMOUNT DECIMAL(8,2));

INSERT INTO DEPOSIT VALUES(101, 'ANIL', 'VRCE', 1000, '01/03/1995');

INSERT INTO DEPOSIT (ACTNO, CNAME, BNAME, AMOUNT, ADATE) VALUES(102, 'SUNIL', 'AJNI', 5000, '04/01/1996');

INSERT INTO DEPOSIT VALUES(103,'MEHUL', 'KAROLBAGH', 3500, '11/11/1995');

INSERT INTO DEPOSIT VALUES(104,'MADHURI', 'CHANDI', 1200, '12/07/1995');

INSERT INTO DEPOSIT VALUES(105,'PRAMOD', 'M.G.ROAD', 3000, '03/27/1995');

INSERT INTO DEPOSIT VALUES(106,'SANDEEP', 'ANDHERI', 2000, '03/31/1996');

INSERT INTO DEPOSIT VALUES(107,'SHIVANI', 'VIRAR', 1000, '09/05/1995');

INSERT INTO DEPOSIT VALUES(108,'KRANTI', 'NEHRU PLACE', 5000, '07/02/1995');

INSERT INTO DEPOSIT VALUES(109,'MINU', 'POWAI', 7000, '08/10/1995');

INSERT INTO BORROW VALUES(201, 'ANIL', 'VRCE', 1000);

INSERT INTO BORROW VALUES(206, 'MEHUL', 'AJNI', 5000);

INSERT INTO BORROW VALUES(311, 'SUNIL', 'DHARAMPETH', 3000);

INSERT INTO BORROW VALUES(321, 'MADHURI', 'ANDHERI', 2000);

INSERT INTO BORROW VALUES(375, 'PRAMOD', 'VIRAR', 8000);

INSERT INTO BORROW VALUES(481, 'KRANTI', 'NEHRU PLACE', 3000);