과제

테이블 (5)

ALGORITHM

  • student_id — 외래 키 → STUDENT.student_id — NOT NULL
  • GRADE
  • ACQUISITION_DATE

ATTENDANCE

  • attendance_id (Key) — 기본 키 — NOT NULL
  • STUDENT_ACCOUNT
  • SIGN_IN
  • SIGN_OUT
  • ATTENDANCE
  • student_id — 외래 키 → STUDENT.student_id — NOT NULL

GRADE

  • Key — 기본 키 — NOT NULL
  • FIRST
  • SECOND
  • THIRD
  • student_id — 외래 키 → STUDENT.student_id — NOT NULL

STUDENT

  • student_id — 기본 키 — NOT NULL
  • ACCOUNT
  • NAME
  • HP
  • AGE
  • GENDER
  • CURRICULUM
  • REGION
  • GROUP
  • REG_USER
  • REG_DT
  • LAST_USER
  • LAST_DT

TEACHER

  • Key — 기본 키 — NOT NULL
  • ID
  • NAME
  • HP