dd

Tables (4)

t_professorList (Untitled4)

  • professorID (Key) — INT — Primary key — NOT NULL
  • professorName (Field) — VARCHAR(50)

t_studentList (Untitled)

  • studentID (Key) — INT — Primary key — NOT NULL
  • studentName (Field) — VARCHAR(50)
  • studentMajor (Field2) — VARCHAR(50)

t_subData (Untitled3)

  • studentID (Key) — INT — Primary key — NOT NULL
  • subjectCode (Field) — VARCHAR(10)

t_subjectList (Untitled2)

  • subjectCode (Key) — VARCHAR(10) — Primary key — NOT NULL
  • subjectName (Field) — VARCHAR(100)
  • professorID (Field2) — INT
  • grade (Field4) — INT