과제1

테이블 (5)

ATTENDANCE (Untitled2)

  • STUDENT_ACCOUNT (Key2) — varchar — 외래 키 → STUDENT.STUDENT_ACCOUNT — NOT NULL
  • DATE (Key) — varchar(20) — 외래 키 → Date.DATE — NOT NULL
  • ATTENDANCE (Field) — boolean
  • ATTENDANCE_SIGN_IN (Field2) — varchar(50)
  • ATTENDANCE_SIGN_OUT (Field3) — varchar(50)

Date (Untitled4)

  • DATE (Key) — varchar(20) — 기본 키 — NOT NULL

GRADE (Untitled3)

  • STUDENT_ACCOUNT (Key3) — varchar — 외래 키 → STUDENT.STUDENT_ACCOUNT — NOT NULL
  • GRADE_FIRST_EXAM (N) — varchar
  • GRADE_SECOND_EXAM (Field2) — varchar
  • GRADE_THIRD_EXAM (Field3) — varchar
  • ALGORITHM_GRADE (Field) — varchar
  • GRADE_PROJECT (Field4) — varchar
  • Field5

REGION (group)

  • STUDENT_REGION (Key) — varchar — 기본 키 — NOT NULL
  • GROUP_TEACHER_ID (Field) — varchar
  • GROUP_TEACHER_NAME (Field2) — varchar
  • GROUP_TEACHER_HP (Field3) — varchar

STUDENT (Untitled)

  • STUDENT_ACCOUNT (Key) — varchar — 기본 키 — NOT NULL
  • STUDENT_NAME (Field2) — varchar
  • STUDENT_HP (Field3) — varchar
  • STUDENT_AGE (Field4) — varchar
  • STUDENT_GENDER (Field5) — varchar
  • STUDENT_CURRICULUM (Field6) — varchar
  • STUDENT_GROUP (Field) — varchar
  • Field8
  • STUDENT_REGION (Key3) — varchar — 외래 키 → REGION.STUDENT_REGION — NOT NULL