REM This script creates two tables Ang, Abt, BONUS1, and SALGRADE1,

REM INSERT INTO is used to input some test data

 CREATE TABLE Abt

       (AbtNr NUMBER(2) CONSTRAINT PK_Abt PRIMARY KEY,

        DNAME VARCHAR2(14) ,

        LOC VARCHAR2(13) ) ;

CREATE TABLE Ang

       (AngNr NUMBER(4) CONSTRAINT PK_Ang PRIMARY KEY,

        ENAME VARCHAR2(10),

        JOB VARCHAR2(9),

        MGR NUMBER(4),

        HIREDATE DATE,

        SAL NUMBER(7,2),

        COMM NUMBER(7,2),

        AbtNr NUMBER(2) CONSTRAINT FK_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);