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)