Oracle Semi Project
테이블 (6)
Course (course)
- Course ID (COURSE_ID) — VARCHAR2(30) — 기본 키 — NOT NULL
- Course Name (COURSE_NAME) — VARCHAR2(30)
- Period Start (PERIOD_START) — DATE
- Period End (PERIOD_END) — DATE
- Classroom (CLASSROOM) — VARCHAR2(30)
과목 (Untitled)
- SUBJECT ID (Key2) — 기본 키 — NOT NULL
- Course ID (Key) — VARCHAR2(30) — 외래 키 → Course.Course ID — NOT NULL
- SUBJECT NAME (Field)
- START DATE (Field2)
- END DATE (Field3)
- BOOK NAME (Field4)
- PROFESSOR (Field5)
성적 (Untitled4)
- Key — 기본 키 — NOT NULL
- 출결 (Field)
- 실기 (Field2)
- 필기 (Field3)
- Field4