quiz

Tables (4)

lecture (수강)

  • StudentNo (Key) — Primary key — NOT NULL
  • StudentNo (Key2) — Foreign key → sudent.StudentNo — NOT NULL
  • SubjectName (Field)

professor (교수)

  • SubjectName (Key) — Foreign key → subject.SubjectName — NOT NULL
  • SubjectName (Key2) — Foreign key → subject.SubjectName — NOT NULL
  • ProfessorName (Field)
  • DepartmentNo (Field2)

subject (과목)

  • SubjectName (Key) — Primary key — NOT NULL
  • SubjectName (Key2) — Foreign key → professor.SubjectName — NOT NULL
  • ClassTime (Field)
  • LectureRoom (Field2)
  • ProfessorNo (Field3)

sudent (학생)

  • StudentNo (Key) — Primary key — NOT NULL
  • StudentName (Field)
  • Major (Field2)
  • Age (Field3)