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