개체관계모델실습
테이블 (4)
DEPARTMENT
- depID — char(5) — 기본 키 — NOT NULL
- name — char(30)
- ssn (managerssn) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL
EMPLOYEE
- ssn — char(14) — 기본 키 — NOT NULL
- Field (name) — char(20)
- address (adress) — char(50)
- phone — char(11)
- depID — char(5) — 외래 키 → DEPARTMENT.depID — NOT NULL
PROJECT
- projectID — char(10) — 기본 키 — NOT NULL
- projectName — char(30)
- description — text
- duration — char(30)
- depID — char(5) — 외래 키 → DEPARTMENT.depID — NOT NULL
Untitled (WORKSON)
- ssn — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- projectID — char(10) — 외래 키 → PROJECT.projectID — NOT NULL