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)