슬라이드 20, 21
테이블 (7)
DEPARTMENT
- Field (deptNo) — char(10) — 기본 키 — NOT NULL
- Field (emplyeeID) — char(10) — 외래 키 → EMPLOYEE.Key — NOT NULL
- Key (locationNumber) — char(5) — 외래 키 → DEPARTMENT-LOCATION.Key — NOT NULL
- Key (name) — char(5)
DEPARTMENT-LOCATION
- Key (locationNumber) — char(5) — 외래 키 → LOCATION.Key — NOT NULL
EMPLOYEE
- Key (emplyeeID) — char(15) — 기본 키 — NOT NULL
- Field (number) — char(10) — 외래 키 → DEPARTMENT.Field — NOT NULL
- Key (locationNumber) — char(5) — 외래 키 → DEPARTMENT.Key — NOT NULL
- Field (name) — char(20)
- Field (gender) — char(1)
- Field (adress) — text
- Field (pay) — char(20)
- Field (ssn) — char(12)
- Field (birthDate) — char(20)
FAMILY
- Key (familyNumber) — char(10) — 기본 키 — NOT NULL
- Field (emplyeeID) — char(15) — 외래 키 → EMPLOYEE.Key — NOT NULL
- Field (number) — char(10) — 외래 키 → EMPLOYEE.Field — NOT NULL
- Key (locationNumber) — char(5) — 외래 키 → EMPLOYEE.Key — NOT NULL
- Field (name) — char(20)
- Field (gender) — char(1)
- Field (birthDate) — char(6)
LOCATION
- Key (locationNumber) — char(5) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (adress) — text
PROJECT (Untitled2)
- Field (projNo) — char(5) — 기본 키 — NOT NULL
- Field (emplyeeID) — char(15) — 외래 키 → PROJECT-EMPLOYEE.Field — NOT NULL
- Key (locationNumber) — char(5) — 외래 키 → PROJECT-EMPLOYEE.Key — NOT NULL
- Key (name) — char(20)
- Field (department) — char(20)
PROJECT-EMPLOYEE (Untitled)
- Field (emplyeeID) — char(15) — 외래 키 → EMPLOYEE.Key — NOT NULL
- Field (projNo) — char(10) — 외래 키 → EMPLOYEE.Field — NOT NULL
- Key (locationNumber) — char(5) — 외래 키 → EMPLOYEE.Key — NOT NULL