학사관리
테이블 (5)
Lecture? (강whk)
- l_num (Key) — 기본 키 — NOT NULL
- d_num (Key2) — 외래 키 → department.d_num — NOT NULL
- l_name (Field)
- drap_Score (Field2)
- gang_time (Field3)
- gang_room (Field4)
department (하고가)
- d_num (Key) — 기본 키 — NOT NULL
- d_name (Field)
- d_phone (Field2)
- t_num (Key2) — 외래 키 → teacher.t_num — NOT NULL
- s_num (Key3) — 외래 키 → student.s_num — NOT NULL
lesson (수강(수업))
- Key — 기본 키 — NOT NULL
- Atten_Score (Field)
- middle_Score (Field2)
- high_Score (Field3)
- guitar_Score (Field4)
- sum_Score (Field5)
- Score_data (Field6)
- l_num (Key2) — 외래 키 → Lecture?.l_num — NOT NULL
- d_num (Key22) — 외래 키 → Lecture?.d_num — NOT NULL
student (학생)
- s_num (Key) — 기본 키 — NOT NULL
- s_name (Field)
- people_num (주민번호임)
- s_addres (Field3)
- s_phone (Field4)
- s_e-mail (Field5)
- s_photo (Field6) — block
teacher (교수)
- t_num (Key) — 기본 키 — NOT NULL
- t_name (Field)
- t_people_num (Field2)
- t_addres (Field3)
- t_phone (Field4)
- t_e-mail (Field5)
- t_photo (Field6) — block