client&server
Tables (3)
TakeSubject (takesubject)
- StudentNum — int — Foreign key → student.StudentNum
- SubjectNum — int — Foreign key → subject.SubjectNum — NOT NULL
student
- StudentNum — int — Primary key
- Name — VARCHAR(100)
- Major — VARCHAR(10)
subject
- SubjectNum — int — Primary key — NOT NULL
- Propessor — VARCHAR(100)
- SubjectName — VARCHAR(100)
- PrerequisiteSubjectNum — int — Foreign key → subject.SubjectNum — NOT NULL