조예림-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)