study

Tables (3)

dept (Untitled)

  • deptno — DECIMAL(10, 0) — Primary key — NOT NULL
  • dname — VARCHAR(14)
  • loc — VARCHAR(13)

emp (Untitled2)

  • empno — DECIMAL(10, 0) — Primary key — NOT NULL
  • deptno — DECIMAL(10, 0) — Foreign key → dept.deptno — NOT NULL
  • ename (Field) — VARCHAR(10)
  • job (Field2) — DECIMAL(4,0)
  • mgr (Field3) — DECIMAL(4,0)
  • hiredate (Field4) — DATE
  • sal (Field5) — DECIMAL(7,2)
  • comm (Field6) — DECIMAL(7,2),

emp_dept_hist (Untitled3)

  • fromdate (Key2) — DATE — Primary key — NOT NULL
  • deptno — DECIMAL(10, 0) — Foreign key → dept.deptno — NOT NULL
  • todate (Field) — DATE