title

Tables (11)

AdvisorId

  • StudentID — VARCHAR(20) — Foreign key → Student.StudentID — NOT NULL

Department

  • DepartmentID — VARCHAR(20) — Primary key — NOT NULL
  • Name — VARCHAR(20)
  • Office — VARCHAR(20)

Operate

  • ProfessorID — VARCHAR(20) — Foreign key → Professor.ProfessorID — NOT NULL
  • DepartmentID — VARCHAR(20) — Foreign key → Department.DepartmentID — NOT NULL

Professor

  • ProfessorID — VARCHAR(20) — Primary key — NOT NULL
  • Name — VARCHAR(20)
  • Age — INTEGER
  • Grade — VARCHAR(20)
  • ResearchField — VARCHAR(20)

Student

  • StudentID — VARCHAR(20) — Primary key — NOT NULL
  • DepartmentID — VARCHAR(20) — Foreign key → Department.DepartmentID — NOT NULL
  • Name — VARCHAR(20)
  • Age — VARCHAR(20)
  • Degree — VARCHAR(20)

Subject

  • SubjectID — VARCHAR(20) — Primary key — NOT NULL
  • SupportOrg — VARCHAR(20)
  • StartDate — VARCHAR(20)
  • EndDate — VARCHAR(20)
  • Budget — VARCHAR(20)

Subject Management

  • SubjectID — VARCHAR(20) — Foreign key → Subject.SubjectID — NOT NULL
  • ProfessorID — VARCHAR(20) — Foreign key → Professor.ProfessorID — NOT NULL

Subject Performance

  • ProfessorID — VARCHAR(20) — Foreign key → Professor.ProfessorID — NOT NULL
  • SubjectID — VARCHAR(20) — Foreign key → Subject.SubjectID — NOT NULL

Subject Performance_Student

  • SubjectID — VARCHAR(20) — Foreign key → Subject.SubjectID — NOT NULL
  • StudentID — VARCHAR(20) — Foreign key → Student.StudentID — NOT NULL

Supervise

  • ProfessorID — VARCHAR(20) — Foreign key → Professor.ProfessorID — NOT NULL
  • SubjectID — VARCHAR(20) — Foreign key → Subject Performance_Student.SubjectID — NOT NULL
  • StudentID — VARCHAR(20) — Foreign key → Subject Performance_Student.StudentID — NOT NULL

Work

  • ProfessorID — VARCHAR(20) — Foreign key → Professor.ProfessorID — NOT NULL
  • DepartmentID — VARCHAR(20) — Foreign key → Department.DepartmentID — NOT NULL
  • Percentage — INTEGER