1대 1
테이블 (5)
class (class_t)
- class name (clname) — varchar2(30) — 기본 키 — NOT NULL
professor (professor_t)
- professor name (proname) — varchar2(30) — 기본 키 — NOT NULL
- class name (clname) — varchar2(30) — 외래 키 → class.class name — NOT NULL
student (student_t)
- stname (sname) — varchar2(30) — 기본 키 — NOT NULL
- class name (clname) — varchar2(30) — 외래 키 → class.class name — NOT NULL
study (study_t)
- stname (sname) — varchar2(30) — 외래 키 → student.stname — NOT NULL
- subname (sbname) — varchar2(30) — 외래 키 → subject.subname — NOT NULL
subject (subject_t)
- subname (sbname) — varchar2(30) — 기본 키 — NOT NULL
- professor name (proname) — varchar2(30) — 외래 키 → professor.professor name — NOT NULL