Database assignment #1

Tables (7)

company worfer (회사원)

  • 사람 구분 코드 (code 1) — Foreign key → participants.사람 구분 코드 — NOT NULL
  • title (Field)
  • level (Field2)
  • position (Field3)

courses (교육과정)

  • 교육 구분 코드 (code2) — Primary key — NOT NULL
  • 사람 구분 코드 (code 1) — Foreign key → participants.사람 구분 코드 — NOT NULL
  • Edition (Key) — Foreign key → edition.Edition — NOT NULL
  • title (Field)

edition (Untitled3)

  • Edition (Key) — Primary key — NOT NULL
  • start dae (Field)
  • end date (Field2)
  • number of participants (Field3)

instructors (교육 강사들)

  • 교육 구분 코드 (code2) — Foreign key → courses.교육 구분 코드 — NOT NULL
  • surname (Field)
  • age (Field2)
  • place of birth (Field3)
  • edition (Field4)
  • taught in the past (Field5)
  • course (Field6)
  • telephone number (Field7)

participants (교육 참가자들)

  • 사람 구분 코드 (code 1) — not null — Primary key — NOT NULL
  • social security number (Field) — not null
  • surname (Field2) — not null
  • age (Field3) — not null
  • sex (Field4) — not null
  • place of birth (Field5) — not null
  • employer's name (Field6) — not null
  • address (Field7) — not null
  • telephone number (Field8) — not null
  • previous employers (Field9) — not null
  • periods employed (Field10) — not null
  • courses attended (Field11) — not null
  • final assassment (Field12) — not null

self-employed (자영업자)

  • 사람 구분 코드 (code 1) — Foreign key → participants.사람 구분 코드 — NOT NULL
  • area of expertise (Field)

seminar (Untitled)

  • 교육 구분 코드 (code2) — Foreign key → courses.교육 구분 코드 — NOT NULL
  • 사람 구분 코드 (code 1) — Foreign key → courses.사람 구분 코드 — NOT NULL
  • place (Field)
  • time (Field2)
  • participants at present (Field3)