시험 대비

테이블 (5)

Attend class (Untitled5)

  • ID (Key) — 외래 키 → Students.ID — NOT NULL
  • ID (Key2) — 외래 키 → subjects.ID — NOT NULL
  • Year (Field)
  • term (Field2)
  • Grade (Field3)

Department (Untitled3)

  • Code (Key) — 기본 키 — NOT NULL
  • tellphone (Field)

Professor (Untitled)

  • ID (Key) — 기본 키 — NOT NULL
  • Lastname (Field)
  • Firstname (Field2)
  • tellphone (Field3)
  • DepartmentCode (Key2) — 외래 키 → Department.Code — NOT NULL

Students (Untitled4)

  • ID (Key) — 기본 키 — NOT NULL
  • Lastname (Field)
  • Firstname (Field2)
  • tellphone (Field3)
  • DepartmentCode (Key2) — 외래 키 → Department.Code — NOT NULL

subjects (Untitled2)

  • ID (Key) — 기본 키 — NOT NULL
  • Name (Field)
  • ProfessorID (Key2) — 외래 키 → Professor.ID — NOT NULL