The Table Structure and data for following tables are listed as follows:

  1. EMP
  2. DEPT
  3. SALGRADE
  4. BONUS
  5. BANK_ACCT

EMP

STRUCTURE

Name Null? Type
EMPNO NOT NULL NUMBER(4)
ENAME   VARCHAR2(10)
JOB   VARCHAR2(9)
MGR   NUMBER(4)
HIREDATE   DATE
SAL   NUMBER(7,2)
COMM   NUMBER(7,2)
DEPTNO   NUMBER(2)

DATA

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
7369 SMITH CLERK 7902 17-DEC-80 800   20
7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
7566 JONES MANAGER 7839 02-APR-81 2975   20
7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30
7698 BLAKE MANAGER 7839 01-MAY-81 2850   30
7782 CLARK MANAGER 7839 09-JUN-81 2450   10
7788 SCOTT ANALYST 7566 09-DEC-82 3000   20
7839 KING PRESIDENT   17-NOV-81 5000   10
7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30
7876 ADAMS CLERK 7788 12-JAN-83 1100   20
7900 JAMES CLERK 7698 03-DEC-81 950   30
7902 FORD ANALYST 7566 03-DEC-81 3000   20
7934 MILLER CLERK 7782 23-JAN-82 1300   40


DEPT

STRUCTURE

Name Null? Type
DEPTNO NOT NULL NUMBER(2)
DNAME   VARCHAR2(14)
LOC   VARCHAR2(13)

DATA

DEPTNO DNAME LOC
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON


SALGRADE

STRUCTURE

Name Null? Type
GRADE   NUMBER
LOSAL   NUMBER
HISAL   NUMBER

DATA

GRADE LOSAL HISAL
1 700 1200
2 1201 1400
3 1401 2000
4 2001 3000
5 3001 9999
1 700 1200
2 1201 1400
3 1401 2000
4 2001 3000
5 3001 9999


BONUS

STRUCTURE

Name Null? Type
ENAME   VARCHAR2(10)
JOB   VARCHAR2(9)
SAL   NUMBER
COMM   NUMBER

BANK_ACCT

STRUCTURE

Name Null? Type
ACCTNO   NUMBER(10)
NAME   VARCHAR2(30)