database_w11

Tables (4)

Department (Untitled)

  • dept_id (Field) — int — Primary key
  • dept_name (Field2) — varchar

Employee (Untitled2)

  • emp_id (Field) — int — Primary key
  • dept_id (Field5) — int — Foreign key → Department.dept_id
  • emp_name (Field2) — varchar
  • position (Field3) — varchar
  • dept_id (Field4) — int

Family (Untitled3)

  • family_id (Field) — int — Primary key
  • emp_id (Field5) — int — Foreign key → Employee.emp_id
  • dept_id (Field52) — int — Foreign key → Employee.dept_id
  • name (Field2) — varchar
  • age (Field3) — int
  • emp_id (Field4) — int

WorkHistory (Untitled4)

  • wh_id (Field) — int — Primary key
  • emp_id (Field6) — int — Foreign key → Employee.emp_id
  • dept_id (Field52) — int — Foreign key → Employee.dept_id
  • dept_id (Field7) — int — Foreign key → Department.dept_id
  • emp_id (Field2) — int
  • dept_id (Field3) — int
  • period (Field4) — varchar
  • position (Field5) — varchar