예제과제
테이블 (4)
Untitled (DEPARTMENT)
- Key (deptNo) — int — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (manager) — char(20)
- Field (managerStartDate) — date
- Key (SSN) — date — 외래 키 → Untitled.Key — NOT NULL
- Key (projNo) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (PROJECT)
- Key (projNo) — int — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (controllingDepartment)
- Key (deptNo) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (SSN) — date — 외래 키 → Untitled.Key — NOT NULL
Untitled (EMPLOYEE)
- Key (SSN) — date — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (gender)
- Field (address)
- Field (salary)
- Field (department)
- Field (supervisor)
- Field (worksOn)
- Key (deptNo) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (dependentName) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPENDENT)
- Key (dependentName) — char(20) — 기본 키 — NOT NULL
- Field (gender)
- Field (birthDate)
- Field (relationship)
- Field (parent)
- Field (ssn)
- Key (SSN) — date — 외래 키 → Untitled.Key — NOT NULL