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