5주차 과제
테이블 (7)
Employee (Untitled)
- employeeNo (Key) — 기본 키 — NOT NULL
- Field5
- name (Field)
- email (Field2)
- address (Field3)
- phone (Field4)
- depNo (Key2) — 외래 키 → department.depNo — NOT NULL
- suvisorNo (Key3) — 외래 키 → Employee.employeeNo — NOT NULL
Location (Untitled3)
- locNO (Key) — 기본 키 — NOT NULL
- phone (Field)
- adress (Field2)
Project (Untitled5)
- proNo (Key) — 기본 키 — NOT NULL
- proName (Field)
- description (Field2)
- depNo (Key2) — 외래 키 → department.depNo — NOT NULL
Works_On (Untitled6)
- employeeNo (Key) — 외래 키 → Employee.employeeNo — NOT NULL
- proNo (Key2) — 외래 키 → Project.proNo — NOT NULL
- hours (Field)
- Field2
department (Untitled2)
- depNo (Key) — 기본 키 — NOT NULL
- depname (Field)
- phone (Field2)
- fax (Field3)
- employeeNo (Key2) — 외래 키 → Employee.employeeNo — NOT NULL
department_Loc (Untitled4)
- depNo (Key2) — 외래 키 → department.depNo — NOT NULL
- locNO (Key3) — 외래 키 → Location.locNO — NOT NULL
dependent (Untitled7)
- deNo (Key) — 기본 키 — NOT NULL
- deName (Field)
- age (Field2)
- employeeNo (Key2) — 외래 키 → Employee.employeeNo — NOT NULL