Query no 1:
CREATE DATABASE SCOTT;
Query no 2:
USE SCOTT;
Query no 3:
CREATE TABLE DEPT(DEPTNO INT(2), DNAME VARCHAR(14), LOC VARCHAR(13), PRIMARY KEY
(DEPTNO));
Query no 4:
INSERT INTO DEPT
VALUES
(10, 'ACCOUNTING', 'NEW YORK'),
(20, 'RESEARCH', 'DALLAS'),
(30, 'SALES', 'CHICAGO'),
(40, 'OPERATIONS', 'BOSTON');
Query no 5:
CREATE TABLE EMP
(
EMPNO INT(4) NOT NULL,
ENAME VARCHAR(8) NOT NULL,
JOB VARCHAR(10) NOT NULL,
MGR INT(4),
HIREDATE DATE,
SAL DECIMAL(7,2),
COMM DECIMAL(7,2),
DEPTNO INT(2),
PRIMARY KEY (EMPNO),
FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO)
);
Query no 6:
INSERT INTO EMP
VALUES
(7369 , 'SMITH' , 'CLERK' , 7902,'1980-12-17', 800, NULL ,20 ),
(7499 , 'ALLEN' , 'SALESMAN' ,7698,'1981-02-20',1600,300,30 ),
(7521 , 'WARD' , 'SALESMAN' ,7698,'1981-02-22',1250,500,30 ),
(7566 , 'JONES' , 'MANAGER' , 7839,'1981-04-02',2975,NULL,20 ),(7654, 'MARTIN' ,
'SALESMAN' ,7698,'1981-09-28',1250, 1400,30 ),(7698 , 'BLAKE' , 'MANAGER' ,
7839,'1981-05-01',2850,NULL,30 ),(7782, 'CLARK' , 'MANAGER' , 7839,'1981-06-
09',2450,NULL,10 ),(7788 , 'SCOTT' , 'ANALYST' , 7566,'1987-04-19',3000,NULL,20 ),
(7839, 'KING' , 'PRESIDENT' ,NULL ,'1981-11-17',5000,NULL,10),(7844, 'TURNER' ,
'SALESMAN' ,7698 ,'1981-09-08',1500,0,30),(7876, 'ADAMS' , 'CLERK' ,7788 ,'1987-05-
29',1100,NULL,20),(7900, 'JAMES' , 'CLERK' ,7698 ,'1981-12-03',950,NULL,30),(7902,
'FORD' , 'ANALYST' ,7566 ,'1981-12-03',3000,NULL,20),(7934, 'MILLER' ,
'CLERK' ,7782 ,'1982-01-23',1300,NULL,10);
