과제1 - 2024-04-01 14:18:35
테이블 (5)
DEPENDENT
- Key (dependentID) — char(13) — 기본 키 — NOT NULL
- Field (dependentName) — char(20)
- Field (gender) — char(2)
- Field (birthDate) — date
- Field (relationship) — char(8)
- Key (empID) — char(13) — 외래 키 — NOT NULL
EMPLOYEE
- Key (empID) — char(13) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (gender) — char(2)
- Field (address) — char(30)
- Field (birthDate) — date
- Field (pay) — char(10)
- Key (deptNo) — char(10) — 외래 키 — NOT NULL
- Field (supervisorName) — char(20)
PROJECT
- Key (projNo) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (location) — char(20)
- Field (contDept) — char(20)
- Key (empID) — char(13) — 외래 키 — NOT NULL
- Key (deptNo) — char(10) — 외래 키 — NOT NULL
Untitled (DEPARTMENT)
- Key (deptNo) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (manager) — char(20)
- Field (managerStartDate) — date
- Key (empID) — char(13) — 외래 키 — NOT NULL
- Key (projNo) — char(10) — 외래 키 — NOT NULL
WORKS-ON
- Key (SSN) — char(20) — 기본 키 — NOT NULL
- Field (projNo) — char(10)
- Field (hours) — char(4)
- Key (deptNo) — char(10) — 외래 키 — NOT NULL