220218

Tables (3)

Department (dept)

  • Department Number (deptno) — CHAR(2) — Primary key — NOT NULL
  • Department Name (deptname) — VARCHAR(20)
  • Department Location (Field2) — VARCHAR(20)

Employees (emp)

  • Employee Number (empno) — CHAR(4) — Primary key
  • Department Number (deptno2) — CHAR(2) — Foreign key → Department.Department Number — NOT NULL
  • Title Number (titleno2) — CHAR(2) — Foreign key → Title.Title Number — NOT NULL
  • Employee Name (empname) — VARCHAR(10)
  • Manager (manager) — CHAR(4) — Foreign key → Employees.Employee Number
  • Salary (salary) — INT(5)
  • Hire Date (hdate) — DATE
  • Title Number (titleno) — CHAR(2)
  • Department Number (deptno) — CHAR(2)

Title (title)

  • Title Number (titleno) — CHAR(2) — Primary key — NOT NULL
  • Title Name (titlename) — VARCHAR(20)