er

Tables (6)

department

  • Key (dept_id) — Primary key — NOT NULL
  • Field (dept_name)

dependent

  • Key (emp_id) — Foreign key → employee.Key — NOT NULL
  • Key (depe_name) — NOT NULL
  • Field (age)

employee

  • Key (emp_id) — Primary key — NOT NULL
  • Key (dept_id) — Foreign key → department.Key — NOT NULL
  • Field (emp_name)

engage

  • Key (emp_id) — Foreign key → employee.Key — NOT NULL
  • Key (proj_id) — Foreign key → project.Key — NOT NULL
  • work_since

manage

  • Key (dept_id) — Foreign key → department.Key — NOT NULL
  • Key (emp_id) — Foreign key → employee.Key — NOT NULL

project

  • Key (proj_id) — Primary key — NOT NULL
  • Field (proj_name)