erd

Tables (4)

department

  • Key (department_id) — Primary key — NOT NULL
  • (school_id) — Foreign key → school.school_id — NOT NULL
  • Field (department_name)

school (school(院))

  • (school_id) — Primary key — NOT NULL
  • Field (school_name)

student

  • Key (student_id) — Primary key — NOT NULL
  • Key (department_id) — Foreign key → department.Key — NOT NULL
  • (school_id) — Foreign key → department.school_id — NOT NULL
  • Field (student_name)

teacher

  • Key (teacher_id) — Primary key — NOT NULL
  • Key (department_id) — Foreign key → department.Key — NOT NULL
  • (school_id) — Foreign key → department.school_id — NOT NULL
  • Field (teacher_name)