SchoolSystem

테이블 (5)

개설강좌 (Untitled3)

  • CLASS_CODE (Key) — NUMBER — 기본 키 — NOT NULL
  • SUBJECT_CODE (Key2) — VARCHAR2(20) — 외래 키 → 과목테이블.SUBJECT_CODE — NOT NULL
  • PROFESSOR_ID (Key3) — NUMBER — 외래 키 → 교수테이블.PROFESSOR_ID — NOT NULL
  • CLASS_TOTALTIME (Field) — NUMBER
  • CLASS_DAY (Field2) — VARCHAR2(15)
  • CLASS_DURATION (Field3) — NUMBER
  • CLASS_WHEN (Field4) — NUMBER
  • ATTENDENCE_WEIGHT (Field5) — NUMBER
  • MIDTERM_WEIGHT (Field6) — NUMBER
  • FINAL_WEIGHT (Field7) — NUMBER
  • HOMEWORK_WEIGHT (Field8) — NUMBER

과목테이블 (Untitled)

  • SUBJECT_CODE (Key) — VARCHAR2(20) — 기본 키 — NOT NULL
  • SUBJECT_NAME (Field) — VARCHAR2(30)
  • CREDIT (Field2) — NUMBER

교수테이블 (Untitled2)

  • PROFESSOR_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • PROFESSOR_NAME (Field) — VARCHAR2(20)
  • PHONE (Field1) — VARCHAR2(30)
  • ADDRESS (Field2) — VARCHAR2(100)
  • Field3

평가테이블 (Untitled5)

  • Index (Key) — NUMBER — 기본 키 — NOT NULL
  • SUBJECT_CODE (Key3) — VARCHAR2(20) — 외래 키 → 학생테이블.SUBJECT_CODE — NOT NULL
  • ATTENDENCE_SCORE (Field) — NUMBER
  • MIDTERM_SCORE (Field2) — NUMBER
  • FINAL_SCORE (Field3) — NUMBER
  • HOMEWORK_SCORE (Field4) — NUMBER
  • TOTALSCORE (Field5) — NUMBER
  • GRADE (Field6) — VARCHAR2(3)

학생테이블 (Untitled4)

  • STUDENT_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • CLASS_CODE (Key2) — NUMBER — 외래 키 → 개설강좌.CLASS_CODE — NOT NULL
  • SUBJECT_CODE (Key3) — VARCHAR2(20) — 외래 키 → 개설강좌.SUBJECT_CODE — NOT NULL
  • PROFESSOR_ID (Key4) — NUMBER — 외래 키 → 개설강좌.PROFESSOR_ID — NOT NULL
  • STUDENT_NAME (Field) — VARCHAR(15)
  • PHONE (Field2) — VARCHAR2(30)
  • ADDRESS (Field3) — VARCHAR2(100)