데이터베이스론_과제1
테이블 (10)
Employment type (et)
- instructors telephone number (i_tn) — NOTNULL — 외래 키 → instructors.instructors telephone number — NOT NULL
- permanent (pm)
- freelance (fr)
company
- code (t_code) — NOTNULL — 외래 키 → trainees.code — NOT NULL
- position held (ph)
- level (lv)
course_edition (c_e)
- courses code (c_code) — NOTNULL — 외래 키 → courses.courses code — NOT NULL
- instructors telephone number (i_tn) — NOTNULL — 외래 키 → courses.instructors telephone number — NOT NULL
- edition number (en) — number
- start date (sd) — date
- end date (ed) — date
- number of participants (nop) — number
courses (course)
- courses code (c_code) — NOTNULL — 기본 키 — NOT NULL
- instructors telephone number (i_tn) — NOTNULL — 외래 키 → instructors.instructors telephone number — NOT NULL
- course title (c_t)
instructors (ins)
- instructors telephone number (i_tn) — NOTNULL — 기본 키 — NOT NULL
- instructors surname (i_sn)
- age (i_age) — number
- place of birth (i_pob)
- tutor's qualify (tq)
past courses (ps_c)
- code (t_code) — NOTNULL — 외래 키 → trainees.code — NOT NULL
- courses code (c_code) — NOTNULL — 외래 키 → courses.courses code — NOT NULL
- instructors telephone number (i_tn) — NOTNULL — 외래 키 → courses.instructors telephone number — NOT NULL
- final assessment (fa)
present courses (pr_c)
- code (t_code) — NOTNULL — 외래 키 → trainees.code — NOT NULL
- courses code (c_code) — NOTNULL — 외래 키 → courses.courses code — NOT NULL
- instructors telephone number (i_tn) — NOTNULL — 외래 키 → courses.instructors telephone number — NOT NULL
- time the classes are held (time_held)
- places (c_place)
previous employers (pr_e)
- previous employers (pe) — NOTNULL — 기본 키 — NOT NULL
- code (t_code) — NOTNULL — 외래 키 → trainees.code — NOT NULL
- employed periods (ep)
self-employed (self)
- code (t_code) — NOTNULL — 외래 키 → trainees.code — NOT NULL
- area of expertise (aoe)
- title (self_title)
trainees (tr)
- code (t_code) — NOTNULL — 기본 키 — NOT NULL
- sosial sevurity number (ssn)
- surname (t_sn)
- age (t_age) — number
- sex (t_sex)
- place of birth (t_pob)
- employer's name (en)
- address (t_ad)
- telephone number (t_tn)