@Prateek

CREATE TABLE EMPLOYEE( EMP_NO INTEGER(5), EMP_NAME VARCHAR(10), EMP_SALARY INTEGER(8), EMP_COMM INTEGER(5), DEPT_NO INTEGER(5) ); INSERT INTO EMPLOYEE VALUES(101,'SMITH',800,NULL,20); INSERT INTO EMPLOYEE VALUES(102,'SNEHAL',1600,300,25);

CREATE TABLE JOB( JOB_ID VARCHAR(10), JOB_TITLE VARCHAR(15), MIN_SALARY INTEGER(8), MAX_SALARY INTEGER(8) ); INSERT INTO JOB VALUES('IT_PROG','PROGRAMMER',4000,10000); INSERT INTO JOB VALUES('MK_MGR','MARKETING_MGR',9000,15000);

CREATE TABLE BORROW( LOAN_NO INTEGER(5), ENAME VARCHAR(10), BNAME VARCHAR(10), AMOUNT INTEGER(8) ); INSERT INTO BORROW VALUES(201,'ANIL','VRCE',1000); INSERT INTO BORROW VALUES(202,'SUNIL','AJNI',5000); INSERT INTO BORROW VALUES(203,'MEHUL','ANDHERI',3000);