a

Tables (3)

Student (student)

  • Key (studentNum) — VARCHAR(100) — Primary key — NOT NULL
  • Field (studentName) — VARCHAR(100)
  • Field (major) — VARCHAR(100)
  • Field (password) — VARCHAR(100)

Subject

  • Key (subjectNum) — VARCHAR(100) — Primary key — NOT NULL
  • Field (propessor) — VARCHAR(100)
  • Field2 (subjectName) — VARCHAR(100)
  • Field3 (prerequisiteSubject1) — VARCHAR(100)
  • Field4 (prerequisiteSubject2) — VARCHAR(100)

takeSubject

  • Key (studentNum) — VARCHAR(100) — Foreign key → Student.Key — NOT NULL
  • Key (subjectNum) — VARCHAR(100) — Foreign key → Subject.Key — NOT NULL