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