Training Company

테이블 (7)

(훈련 과정) 회차 (edition)

  • edition (Field4) — 기본 키
  • C-code (Key2) — 외래 키 → 훈련 과정.C-code — NOT NULL
  • telephone numbers (Key) — 외래 키 → 강사.telephone numbers — NOT NULL
  • number of participant (Field)
  • start date (Field2)
  • end date (Field3)

강사 (instructor)

  • telephone numbers (Key) — 기본 키 — NOT NULL
  • C-code (Key2) — 외래 키 → 훈련 과정.C-code — NOT NULL
  • surname (Field)
  • age (Field2)
  • place of birth (Field3)
  • permanently employed (Field4)
  • freelance (Field5)
  • edtion of course(taught) (Field7)
  • courses(taught) (Field8)

고용이력 (Untitled)

  • P-code (Key) — 외래 키 → 과정 참여자.P-code — NOT NULL
  • previous employers (Field)
  • periods emplyed (Field2)

과거 참여한 과정 (course attended)

  • P-code (Key) — 외래 키 → 과정 참여자.P-code — NOT NULL
  • C-code (Key2) — 외래 키 → 훈련 과정.C-code — NOT NULL
  • final assessment (Field2)

과정 참여자 (course participant)

  • P-code (Key) — 기본 키 — NOT NULL
  • edition (Field42) — 외래 키 → 세미나.edition
  • C-code (Key2) — 외래 키 → 세미나.C-code — NOT NULL
  • social security number (Field)
  • surname (Field2)
  • age (Field3)
  • sex (Field4)
  • place of birth (Field8)
  • address (Field9)
  • telephone number (Field10)
  • employer's name (Field6)
  • 고용형태 (Field5) — self employed or work for company
  • title (Field7)
  • area of expertise (Field11)
  • position (Field12)
  • level (Field13)

세미나 (seminars)

  • edition (Field42) — 외래 키 → (훈련 과정) 회차.edition
  • C-code (Key2) — 외래 키 → (훈련 과정) 회차.C-code — NOT NULL
  • telephone numbers (Key3) — 외래 키 → (훈련 과정) 회차.telephone numbers — NOT NULL
  • place (Field)
  • time (Field2)
  • day (Field4)

훈련 과정 (course)

  • C-code (Key) — 기본 키 — NOT NULL
  • title (Field)