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)