정윤호_20163584

테이블 (8)

course (Untitled2)

  • course_code (Key) — 기본 키 — NOT NULL
  • title (Field)

course participant (Untitled)

  • social security number (Key) — 기본 키 — NOT NULL
  • participant_code (Key2) — 기본 키 — NOT NULL
  • course_code (Key3) — 외래 키 → courses_attended.course_code — NOT NULL
  • surname (Field)
  • age (Field2)
  • sex (Field3)
  • place of birth (Field4)
  • employer's name (Field5)
  • address (Field6)
  • telephone number (Field7)
  • previous employers (Field8)
  • periods employed (Field9)

courses_attended (Untitled8)

  • course_code (Key) — 외래 키 → course.course_code — NOT NULL
  • courses attended (Field)
  • final assessment for each course (Field2)

edition (Untitled3)

  • course_code (Key) — 외래 키 → course.course_code — NOT NULL
  • start date (Field)
  • end date (Field2)
  • number of participants (Field3)

instructor (Untitled5)

  • course_code (Key) — 외래 키 → instructor_course.course_code — NOT NULL
  • surname (Field)
  • place of birth (Field2)
  • telephone numbers (Field3)
  • freelance or working for company (Field4)

instructor_course (Untitled7)

  • course_code (Key) — 외래 키 → edition.course_code — NOT NULL
  • the edition of the course taught (Field)
  • courses taught in the past (Field2)
  • courses that tutor is qualified to teach (Field3)

trainee_self-employed (Untitled4)

  • social security number (Key) — 외래 키 → course participant.social security number — NOT NULL
  • participant_code (Key2) — 외래 키 → course participant.participant_code — NOT NULL
  • course_code (Key3) — 외래 키 → course participant.course_code — NOT NULL
  • area of expertise (Field)
  • title (Field2)

trainee_works for company (Untitled6)

  • social security number (Key) — 외래 키 → course participant.social security number — NOT NULL
  • participant_code (Key2) — 외래 키 → course participant.participant_code — NOT NULL
  • course_code (Key3) — 외래 키 → course participant.course_code — NOT NULL
  • level (Field)
  • position (Field2)