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