ORQCLE main tables

create table EMPLOYEES
(
EMPNO number(4) not null,
ENAME varchar2(8) not null,
JOB varchar2(8),
MGR number(4),
BDATE date,
MSAL number(6,2) not null,
COMM number(6,2),
DEPTNO number(2) not null
);

INSERT INTO EMPLOYEES
(
EMPNO,
ENAME,
JOB,
MGR,
BDATE,
MSAL,
COMM,
DEPTNO
)
VALUES
(
7369,
'SMITH',
'SALESMAN',
7902,
'17-DEC-80',
800,
NULL,
20
);
INSERT INTO EMPLOYEES VALUES(7499,'ALLEN','CLERK',7698,'20-FEB-81',1600,300,30);

INSERT INTO EMPLOYEES(EMPNO,ENAME,JOB,MGR,BDATE,SAL,COMM,DEPTNO)VALUES(7521,'WARD','SALESMAN',7698,'22-FEB-81',1250,500,30);

INSERT INTO EMPLOYEES(EMPNO,ENAME,JOB,MGR,BDATE,MSAL,COMM,DEPTNO)VALUES(7566,'JONES','MANAGER',7839,'02-APR-81',2975,NULL,20);
INSERT INTO EMPLOYEES(EMPNO,ENAME,JOB,MGR,BDATE,MSAL,COMM,DEPTNO)VALUES(7654,'MARTIN','SALESMAN',7698,'28-SEP-81',1250,1400,30);
INSERT INTO EMPLOYEES(EMPNO,ENAME,JOB,MGR,BDATE,MSAL,COMM,DEPTNO)VALUES(7698,'BLAKE','MANAGER',7839,'01-MAY-81',2850,NULL,30);
INSERT INTO EMPLOYEES(EMPNO,ENAME,JOB,MGR,BDATE,MSAL,COMM,DEPTNO)VALUES(7782,'CLARK','MANAGER',7839,'09-JUN-81',2450,NULL,10);
INSERT INTO EMPLOYEES(EMPNO,ENAME,JOB,MGR,BDATE,MSAL,COMM,DEPTNO)VALUES(7788,'SCOTT','ANALYST',7566,'09-DEC-82',3000,NULL,20);
INSERT INTO EMPLOYEES(EMPNO,ENAME,JOB,MGR,BDATE,MSAL,COMM,DEPTNO)VALUES(7839,'KING','PRESIDENT',NULL,'17-NOV-81',5000,NULL,10);
INSERT INTO EMPLOYEES(EMPNO,ENAME,JOB,MGR,BDATE,MSAL,COMM,DEPTNO)VALUES(7844,'TURNER','SALESMAN',7698,'08-SEP-81',1500,0,30);
INSERT INTO EMPLOYEES(EMPNO,ENAME,JOB,MGR,BDATE,MSAL,COMM,DEPTNO)VALUES(7876,'ADAMS','CLERK',7788,'12-JAN-83',1100,NULL,20);
INSERT INTO EMPLOYEES(EMPNO,ENAME,JOB,MGR,BDATE,MSAL,COMM,DEPTNO)VALUES(7900,'JAMES','CLERK',7698,'03-DEC-81',950,NULL,30);
INSERT INTO EMPLOYEES(EMPNO,ENAME,JOB,MGR,BDATE,MSAL,COMM,DEPTNO)VALUES(7902,'FORD','ANALYST',7566,'03-DEC-81',3000,NULL,20);
INSERT INTO EMPLOYEES(EMPNO,ENAME,JOB,MGR,BDATE,MSAL,COMM,DEPTNO)VALUES(7934,'MILLER','CLERK',7782,'23-JAN-82',1300,NULL,10);





create table DEPARTMENTS
(
deptno number(2) not null,
dname varchar2(10) not null,
location varchar2(8) not null,
mgr number(4)
)
INSERT INTO DEPARTMENTS
(
deptno,
dname,
location,
mgr
)
VALUES
(
10,
'ACCOUNTING',
'NEW YORK',
7782
);
INSERT INTO DEPARTMENTS(deptno,dname,location,mgr)VALUES(20,'RESEARCH','DALLAS',7756);
INSERT INTO DEPARTMENTS(deptno,dname,location,mgr)VALUES(30,'SALES','CHICAGO',7698);
INSERT INTO DEPARTMENTS(deptno,dname,location,mgr)VALUES(40,'OPERATION','BOSTON',7839);


--> The SALGRADES Table
create table SALGRADES
( grade number(2) not null
, lowerlimit number(6,2) not null
, upperlimit number(6,2) not null
, bonus number(6,2) not null );



--> The COURSES Table
create table COURSES
( code varchar2(6) not null
, description varchar2(30) not null
, category char(3) not null
, duration number(2) not null );



--> The OFFERINGS Table
create table OFFERINGS
( course varchar2(6) not null
, begindate date not null
, trainer number(4)
, location varchar2(8) );



--> The REGISTRATIONS Table
create table REGISTRATIONS
( attendee number(4) not null
, course varchar2(6) not null
, begindate date not null
, evaluation number(1) );



-->The HISTORY Table
create table HISTORY
( empno number(4) not null
, beginyear number(4) not null
, begindate date not null
, enddate date
, deptno number(2) not null
, msal number(6,2) not null
, comments varchar2(60) );