REM This script creates two tables Ang, Abt, BONUS1, and SALGRADE1, 
REM INSERT INTO is used to input some test data

DROP Table Abt;
DROP Table Ang;
DROP Table BONUS1;
DROP TABLE SALGRADE1;

CREATE TABLE Abt
(AbtNr NUMBER(2) PRIMARY KEY,
DNAME VARCHAR2(14),
LOC VARCHAR2(13) );

CREATE TABLE Ang
(AngNr NUMBER(4) PRIMARY KEY,
ENAME VARCHAR2(10), 
JOB VARCHAR2(9), 
MGR NUMBER(4), 
HIREDATE DATE, 
SAL NUMBER(7,2), 
COMM NUMBER(7,2), 
AbtNr NUMBER(2),
Foreign Key (AbtNr) REFERENCES Abt);

INSERT INTO Abt VALUES (10,'ACCOUNTING','Luzern'); 
INSERT INTO Abt VALUES (20,'RESEARCH','Bale'); 
INSERT INTO Abt VALUES (30,'SALES','Neuchatel'); 
INSERT INTO Abt VALUES (40,'OPERATIONS','Bern'); 

INSERT INTO Ang VALUES (7654,'MARTIN','SALESMAN',7698,to_date('28-9-1981','dd-mm-yyyy'),1250,1400,30); 
INSERT INTO Ang VALUES (7698,'BLAKE','MANAGER',7839,to_date('1-5-1981','dd-mm-yyyy'),2850,NULL,30); 
INSERT INTO Ang VALUES (7782,'NOURI','MANAGER',7839,to_date('9-6-1981','dd-mm-yyyy'),2450,NULL,10); 

CREATE TABLE BONUS1 ( 
ENAME VARCHAR2(10), 
JOB VARCHAR2(9), 
SAL NUMBER, 
COMM NUMBER ) ; 

CREATE TABLE SALGRADE1
( GRADE NUMBER,
LOSAL NUMBER,
HISAL NUMBER );

INSERT INTO SALGRADE1 VALUES (1,700,1200); 
INSERT INTO SALGRADE1 VALUES (2,1201,1400); 
INSERT INTO SALGRADE1 VALUES (3,1401,2000); 
INSERT INTO SALGRADE1 VALUES (4,2001,3000); 
INSERT INTO SALGRADE1 VALUES (5,3001,9999);