SCOTT

Tables (4)

BONUS

  • ENAME — VARCHAR2(10)
  • JOB — VARCHAR2(9)
  • SAL — NUMBER
  • COMM — NUMBER

DEPT

  • DEPTNO — NUMBER(2,0) — Primary key — NOT NULL
  • DNAME — VARCHAR2(14)
  • LOC — VARCHAR2(13)

EMP

  • EMPNO — NUMBER(4) — Primary key — NOT NULL
  • ENAME — VARCHAR2(10)
  • JOB — VARCHAR2(9)
  • MGR — NUMBER(4,0)
  • HIREDATE — DATE
  • SAL — NUMBER(7,2)
  • COMM — NUMBER(7,2)
  • DEPTNO — NUMBER(2,0) — Foreign key → DEPT.DEPTNO — NOT NULL

SALGRADE

  • GRADE — NUMBER
  • LOSAL — NUMBER
  • HISAL — NUMBER
  • Field