망
테이블 (8)
company (Untitled7)
- participant, employee (Key) — 기본 키 — NOT NULL
course participant (Untitled)
- participant code (code) — not null — 기본 키 — NOT NULL
- participant code (code2) — not null — 외래 키 → seminar.participant code — NOT NULL
- edition code (Key) — 외래 키 → edition.edition code — NOT NULL
- participant code (code3) — not null — 외래 키 → edition.participant code — NOT NULL
- participant code (code22) — not null — 외래 키 → edition.participant code — NOT NULL
- social security number — not null
- surname — not null
- age
- sex
- place of birth (Field2)
- employer’s name (Field3)
- address (Field4)
- telephone number (Field5)
- previous employers (Field6)
- periods employed (Field7)
- the courses attended (Field8)
- final assessment for each course (Field9)
edition (Untitled5)
- edition code (Key) — 기본 키 — NOT NULL
- participant code (code) — not null — 외래 키 → course participant.participant code — NOT NULL
- participant code (code2) — not null — 외래 키 → course participant.participant code — NOT NULL
- edition code (Key2) — 외래 키 → course participant.edition code — NOT NULL
- participant code (code3) — not null — 외래 키 → course participant.participant code — NOT NULL
- participant code (code22) — not null — 외래 키 → course participant.participant code — NOT NULL
- title (Field2)
- start date (Field3)
- end date (Field4)
- the number of participants (Field5)
instructor (Untitled2)
- participant code (code) — not null — 외래 키 → course participant.participant code — NOT NULL
- participant code (code2) — not null — 외래 키 → course participant.participant code — NOT NULL
- edition code (Key) — 외래 키 → course participant.edition code — NOT NULL
- participant code (code3) — not null — 외래 키 → course participant.participant code — NOT NULL
- participant code (code22) — not null — 외래 키 → course participant.participant code — NOT NULL
- edition of the course taught (Field)
- edition taught in the past (Field2)
- courses that the tutor is qualified to teach (Field3)
non self-employed trainee (Untitled3)
- participant code (code) — not null — 외래 키 → course participant.participant code — NOT NULL
- participant code (code2) — not null — 외래 키 → course participant.participant code — NOT NULL
- edition code (Key) — 외래 키 → course participant.edition code — NOT NULL
- participant code (code3) — not null — 외래 키 → course participant.participant code — NOT NULL
- participant code (code22) — not null — 외래 키 → course participant.participant code — NOT NULL
self-employed trainee (Untitled8)
- participant code (code) — not null — 외래 키 → course participant.participant code — NOT NULL
- participant code (code2) — not null — 외래 키 → course participant.participant code — NOT NULL
- edition code (Key) — 외래 키 → course participant.edition code — NOT NULL
- participant code (code3) — not null — 외래 키 → course participant.participant code — NOT NULL
- participant code (code22) — not null — 외래 키 → course participant.participant code — NOT NULL
- area of expertise (Field)
- title (Field2)
seminar (Untitled4)
- participant code (code) — not null — 외래 키 → course participant.participant code — NOT NULL
- participant code (code2) — not null — 외래 키 → course participant.participant code — NOT NULL
- edition code (Key) — 외래 키 → course participant.edition code — NOT NULL
- participant code (code3) — not null — 외래 키 → course participant.participant code — NOT NULL
- participant code (code22) — not null — 외래 키 → course participant.participant code — NOT NULL
- place the classes are held (place)
- time the classes are held (time)
somebody who works for a company (Untitled6)
- participant, employee (Key) — 외래 키 → company.participant, employee — NOT NULL
- level (Field)
- position (Field2)