exercise 4

Tables (6)

research (연구)

  • researchid (Key) — Primary key — NOT NULL
  • teacherid (Key2) — Foreign key → teacher.teacherid — NOT NULL
  • researchname (Field)
  • email (Field2)
  • memo (Field3)

teacher (강사)

  • teacherid (Key) — Primary key — NOT NULL
  • teachername (Field)
  • teacherssn (Field2)
  • address (Field3)
  • phone (Field4)
  • email (Field5)

teaching team (교육팀)

  • teamid (Key) — Primary key — NOT NULL
  • teacherid (Key2) — Foreign key → teacher.teacherid — NOT NULL
  • phone (Field)
  • email (Field2)

technology course (강좌)

  • subjectid (Key) — Primary key — NOT NULL
  • teamid (Key2) — Foreign key → teaching team.teamid — NOT NULL
  • teacherid (Key22) — Foreign key → teaching team.teacherid — NOT NULL
  • subjectname (Field)
  • phone (Field2)

trainee (교육생)

  • traineeid (Key) — Primary key — NOT NULL
  • traineename (Field)
  • traineessn (Field2)
  • address (Field3)
  • phone (Field4)
  • email (Field5)
  • teacherid (Key2) — Foreign key → teacher.teacherid — NOT NULL

training session (세션)

  • sessionid (Key) — Primary key — NOT NULL
  • score (Field)
  • subjectid (Key3) — Foreign key → technology course.subjectid — NOT NULL
  • traineeid (Key2) — Foreign key → trainee.traineeid — NOT NULL
  • teamid (Key22) — Foreign key → technology course.teamid — NOT NULL
  • teacherid (Key222) — Foreign key → technology course.teacherid — NOT NULL