PracticeERD

Tables (3)

dept (Untitled)

  • DEPTNO (key) — INT — Primary key — NOT NULL
  • DNAME (Field2) — VARCHAR
  • LOC (Field3) — VARCHAR

emp (Untitled2)

  • EMPNO (Key) — INT — Primary key — NOT NULL
  • DEPTNO (key2) — INT — Foreign key → dept.DEPTNO — NOT NULL
  • EMPNO (Field) — INT
  • ENAME (Field2) — VARCHAR
  • JOB (Field3) — VARCHAR
  • MGR (Field4) — INT
  • HIREDATE (Field5) — DATE
  • SAL (Field6) — INT
  • COMM (Field7) — INT
  • DEPTNO (Field8)
  • Field9

salgrade

  • GARDE (GRADE) — INT
  • LOSAL — INT
  • HISAL — INT