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)