퍼스널 시스템

테이블 (5)

Charge (charge)

  • Teacher_id (teacher_id) — number(10)

Mate (mate)

  • Student_id (student_id) — number(10) — 외래 키 → Student.Student_id — NOT NULL
  • Attendance (attendance) — number(5)
  • Attitude (attitude) — number(5)
  • Participation (participation) — number(5)

Score (score)

  • Student_id (student_id2) — number(10) — 외래 키 → Student.Student_id — NOT NULL
  • Pretest (pretest) — number(5)
  • Python (python) — number(5)
  • Festival (festival) — number(5)

Student (student)

  • Student_id (student_id) — number(10) — 기본 키 — NOT NULL
  • Classroom (classroom.) — number(10) — 기본 키 — NOT NULL
  • Name (name) — varchar2(20)
  • Age (age) — number(5)
  • Major (major) — varchar2(5)
  • Sex (sex) — varchar2(5)

Teacher (teacher)

  • Classroom (classroom.) — number(10) — 외래 키 → Student.Classroom — NOT NULL
  • Teacher_id (teacher_id) — number(10)
  • Name (name) — varchar2(20)
  • Couse_name (couse_name) — varchar2(20)