데이터베이스론_과제1

테이블 (10)

Employment type (et)

  • instructors telephone number (i_tn) — NOTNULL — 외래 키 → instructors.instructors telephone number — NOT NULL
  • permanent (pm)
  • freelance (fr)

company

  • code (t_code) — NOTNULL — 외래 키 → trainees.code — NOT NULL
  • position held (ph)
  • level (lv)

course_edition (c_e)

  • courses code (c_code) — NOTNULL — 외래 키 → courses.courses code — NOT NULL
  • instructors telephone number (i_tn) — NOTNULL — 외래 키 → courses.instructors telephone number — NOT NULL
  • edition number (en) — number
  • start date (sd) — date
  • end date (ed) — date
  • number of participants (nop) — number

courses (course)

  • courses code (c_code) — NOTNULL — 기본 키 — NOT NULL
  • instructors telephone number (i_tn) — NOTNULL — 외래 키 → instructors.instructors telephone number — NOT NULL
  • course title (c_t)

instructors (ins)

  • instructors telephone number (i_tn) — NOTNULL — 기본 키 — NOT NULL
  • instructors surname (i_sn)
  • age (i_age) — number
  • place of birth (i_pob)
  • tutor's qualify (tq)

past courses (ps_c)

  • code (t_code) — NOTNULL — 외래 키 → trainees.code — NOT NULL
  • courses code (c_code) — NOTNULL — 외래 키 → courses.courses code — NOT NULL
  • instructors telephone number (i_tn) — NOTNULL — 외래 키 → courses.instructors telephone number — NOT NULL
  • final assessment (fa)

present courses (pr_c)

  • code (t_code) — NOTNULL — 외래 키 → trainees.code — NOT NULL
  • courses code (c_code) — NOTNULL — 외래 키 → courses.courses code — NOT NULL
  • instructors telephone number (i_tn) — NOTNULL — 외래 키 → courses.instructors telephone number — NOT NULL
  • time the classes are held (time_held)
  • places (c_place)

previous employers (pr_e)

  • previous employers (pe) — NOTNULL — 기본 키 — NOT NULL
  • code (t_code) — NOTNULL — 외래 키 → trainees.code — NOT NULL
  • employed periods (ep)

self-employed (self)

  • code (t_code) — NOTNULL — 외래 키 → trainees.code — NOT NULL
  • area of expertise (aoe)
  • title (self_title)

trainees (tr)

  • code (t_code) — NOTNULL — 기본 키 — NOT NULL
  • sosial sevurity number (ssn)
  • surname (t_sn)
  • age (t_age) — number
  • sex (t_sex)
  • place of birth (t_pob)
  • employer's name (en)
  • address (t_ad)
  • telephone number (t_tn)