test

Tables (4)

A (Untitled)

  • DEPTNO (Key) — Foreign key → DEPT.DEPTNO — NOT NULL
  • JOB (Field)
  • TOT_SAL (Field2)

B (Untitled4)

  • EMPNO (Key) — Foreign key → EMP.EMPNO — NOT NULL
  • DNAME (Field)
  • TOT_SAL (Field2)
  • RUNNING_SUM (Field3)
  • RANK (Field4)

DEPT (Untitled3)

  • DEPTNO (Key) — Primary key — NOT NULL
  • DNAME (Field)
  • LOC (Field2)

EMP (Untitled2)

  • EMPNO (Key) — Primary key — NOT NULL
  • ENAME (Field)
  • JOB (Field2)
  • MGR (Field3)
  • HIRDATE (Field4)
  • SAL (Field5)
  • COMM (Field6)
  • DEPTNO (Key2) — Foreign key → DEPT.DEPTNO — NOT NULL