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)