create table `dept` (
	`deptno` int (2),
	`dname` varchar (60),
	`loc` varchar (60),
	primary key(deptno),
	index dept_index(deptno)
)ENGINE=INNODB DEFAULT CHARSET=utf8; 
insert into `dept` (`deptno`, `dname`, `loc`) values('10','ACCOUNTING','NEW YORK');
insert into `dept` (`deptno`, `dname`, `loc`) values('20','RESEARCH','DALLAS');
insert into `dept` (`deptno`, `dname`, `loc`) values('30','SALES','CHICAGO');
insert into `dept` (`deptno`, `dname`, `loc`) values('40','OPERATIONS','BOSTON');

CREATE TABLE `emp` (
	`empno` INT (4) primary key,
	`ename` VARCHAR (60),
	`job` VARCHAR (30),
	`mgr` INT (4),
	`hiredate` DATE ,
	`sal` FLOAT ,
	`comm` FLOAT ,
	`deptno` INT (2),
	index emp_index(deptno),
	foreign key(deptno) references dept(deptno) on delete cascade on update cascade 
)ENGINE=INNODB DEFAULT CHARSET=utf8; 
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7369','SMITH','CLERK','7902','1980-12-17','800.00',NULL,'20');
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7499','ALLEN','SALESMAN','7698','1981-02-20','1600.00','300.00','30');
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7521','FORD','SALESMAN','7698','1981-02-22','1250.00','500.00','20');
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7566','JONES','MANAGER','7839','1981-04-02','2975.00',NULL,'20');
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7654','MARTIN','SALESMAN','7698','1981-09-28','1250.00','1400.00','30');
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7698','BLAKE','MANAGER','7839','1981-05-01','2850.00',NULL,'30');
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7782','CLARK','MANAGER','7839','1981-06-09','2450.00',NULL,'10');
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7788','SCOTT','ANALYST','7566','1987-04-19','3000.00',NULL,'20');
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7839','KING','PRESIDENT',NULL,'1981-11-17','5000.00',NULL,'10');
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7844','TURNER','SALESMAN','7698','1981-09-08','1500.00','0.00','30');
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7876','ADAMS','CLERK','7788','1987-05-23','2200.00',NULL,'20');
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7900','JAMES','CLERK','7698','1981-12-03','950.00',NULL,'30');
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7902','FORD','ANALYST','7566','1981-12-03','3000.00',NULL,'20');
INSERT INTO `emp` (`empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno`) VALUES('7934','MILLER','CLERK','7782','1982-01-23','1300.00',NULL,'10');


create table `salgrade` (
	`grade` int (1) primary key,
	`losal` float ,
	`hisal` float 
); 

insert into `salgrade` (`grade`, `losal`, `hisal`) values('1','700.00','1200.00');
insert into `salgrade` (`grade`, `losal`, `hisal`) values('2','1201.00','1400.00');
insert into `salgrade` (`grade`, `losal`, `hisal`) values('3','1401.00','2000.00');
insert into `salgrade` (`grade`, `losal`, `hisal`) values('4','2001.00','3000.00');
insert into `salgrade` (`grade`, `losal`, `hisal`) values('5','3001.00','9999.00');