과제
테이블 (8)
Copy Of Untitled (CopyOfemploytee)
- Key (empSSN) — char(14) — 기본 키 — NOT NULL
- Field (empName) — char(30)
- Field (department) — int
- Key (proName) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPARTMENT)
- Key (depID) — int — 기본 키 — NOT NULL
- Field (depName) — char(20)
- Field (depLocation) — char(20)
- Field (manager) — int
- Field (managerStartDate) — date
- Key (empSSN) — char(14) — 외래 키 → Untitled2.Key — NOT NULL
Untitled (employee)
- Key (empSSN) — char(14) — 기본 키 — NOT NULL
- Field (empName) — char(30)
- Field (department) — int
- Key (dependentName) — char(20) — 외래 키 → Untitled2.Key — NOT NULL
Untitled (project)
- Key (proName) — char(20) — 기본 키 — NOT NULL
- Field (proLocation) — char(20)
- Field (conrtrollingDepartment) — int
- Key (empSSN) — char(14) — 외래 키 → Copy Of Untitled.Key — NOT NULL
Untitled2 (EMPLOYEE)
- Key (empSSN) — char(14) — 기본 키 — NOT NULL
- Field (empName) — char(30)
- Field (department) — int
- Key (depID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled2 (DEPENDENT)
- Key (dependentName) — char(20) — 기본 키 — NOT NULL
- Field (gender) — int
- Field (birthDate) — date
- Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL
Untitled3 (department)
- Key (depID) — int — 기본 키 — NOT NULL
- Field (depName) — char(20)
- Field (depLocation) — char(20)
- Field (manager) — int
- Field (managerStartDate) — date
- Key (proName) — char(20) — 외래 키 → Untitled4.Key — NOT NULL
Untitled4 (PROJECT)
- Key (proName) — char(20) — 기본 키 — NOT NULL
- Field (proLocation) — char(20)
- Field (controllingDepartment) — int
- Key (depID) — int — 외래 키 → Untitled3.Key — NOT NULL