조예림-20175609

테이블 (6)

course (Untitled3)

  • code (course code) — 기본 키 — NOT NULL
  • telephone number (Key) — 외래 키 → instructor.telephone number — NOT NULL
  • title (Field)

edition (Untitled4)

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

instructor (Untitled5)

  • telephone number (instructor tp) — 기본 키 — NOT NULL
  • surname (Field)
  • age (Field2)
  • place of birth (Field3)
  • edition of the course taught (Field4)
  • edition taught in the past (Field5)
  • course that the tutor is qualified to teach (Field6)

seminar (Untitled2)

  • code (trainee code) — not null — 외래 키 → trainee.code — NOT NULL
  • code (course code) — 외래 키 → trainee.code — NOT NULL
  • telephone number (Key) — 외래 키 → trainee.telephone number — NOT NULL
  • place the classes are held (Field)
  • time the classes are held (Field2)

somebody who works for a company (Untitled6)

  • level (Field)
  • position (Field2)

trainee (Untitled)

  • code (trainee code) — not null — 기본 키 — NOT NULL
  • code (course code) — 외래 키 → course.code — NOT NULL
  • telephone number (Key) — 외래 키 → course.telephone number — NOT NULL
  • social security number (Field)
  • surname (Field2)
  • age (Field3)
  • sex (Field4)
  • place of birth (Field5)
  • employer's name (Field6)
  • address (Field7)
  • telephone number (Field8)
  • previous employer (Field9)
  • periods employed (Field10)
  • the courses attended (Field11)
  • final assessment for each course (Field12)
  • area of expertise (Field13)
  • title (Field14)