afdsa

Tables (7)

Department

  • DepartmentID — INT
  • Name — VARCHAR(100)
  • Office — VARCHAR(100)
  • HeadProfessorID — INT

GraduateStudent

  • StudentID — INT
  • Name — VARCHAR(100)
  • Age — INT
  • Degree — VARCHAR(50)
  • DepartmentID — INT
  • AdvisorID — INT

Professor

  • ProfessorID — INT
  • Name — VARCHAR(100)
  • Age — INT
  • Grade — VARCHAR(50)
  • ResearchField — VARCHAR(100)

Professor_Department

  • ProfessorID — INT
  • DepartmentID — INT
  • ParticipationRate — DECIMAL(5, 2)

Professor_Subject

  • ProfessorID — INT
  • SubjectID — INT

Subject

  • SubjectID — INT
  • SupportOrg — VARCHAR(100)
  • StartDate — DATE
  • EndDate — DATE
  • Budget — DECIMAL(15, 2)
  • ManagerID — INT

Subject_GraduateStudent

  • SubjectID — INT
  • StudentID — INT