퍼스널 시스템
테이블 (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)