학사관리

테이블 (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