과제1-1
테이블 (8)
Untitled (DEPARTMENT)
- Key (deptNo) — char(5) — 기본 키 — NOT NULL
- Field (name) — char(3)
- Field (manager) — char(3)
- Field (managerStartDate) — char(6)
- Key (employeeNumber) — char(8) — 외래 키 → Untitled.Key — NOT NULL
Untitled (EMPLOYEE)
- Key (employeeNumber) — char(8) — 기본 키 — NOT NULL
- Field (name) — char(3)
- Field (gender) — integer(1)
- Field (address) — char(12)
- Field (salary) — integer(11)
- Field (birthDate) — integer(8)
- Field (department) — char(3)
- Field (supervisor) — char(3)
- Key (deptNo) — char(5) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPT-LOCATION)
- Key (deptNo) — char(5) — 외래 키 → Untitled.Key — NOT NULL
- Key (PlaceNumber) — integer(11) — 외래 키 → Untitled.Key — NOT NULL
Untitled (LOCATION)
- Key (PlaceNumber) — integer(11) — 기본 키 — NOT NULL
- Field (PlaceName) — char(8)
- Field2 (address) — char(16)
Untitled (DEPENDENT)
- Key (Dependency number) — char(8) — 기본 키 — NOT NULL
- Field (name) — char(3)
- Field2 (gender) — integer(1)
- Field3 (birthDate) — char(6)
- Field4 (Relationship) — char(8)
- Key (employeeNumber) — char(8) — 외래 키 → Untitled.Key — NOT NULL
Untitled (A PROJECT EMPLOYEE)
- Field (Position) — char(9)
- Field2 (Participation Rate) — integer(3)
- Field3 (Salary) — integer(8)
- Key (employeeNumber) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Key (ProjectNo) — char(7) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PROJECT)
- Key (ProjectNo) — char(7) — 기본 키 — NOT NULL
- Field (name) — char(8)
- Field2 (Department) — char(3)
- Field3 (Period) — char(8)
- Field4 (Price) — integer(8)
- Key (deptNo) — char(5) — 외래 키 → Untitled.Key — NOT NULL
Untitled (WORKSON)
- Key (employeeNumber) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Key (ProjectNo) — char(7) — 외래 키 → Untitled.Key — NOT NULL
- Field (ProjectID) — char(8)
- Field2 (hours) — float
- Field3 (Field) — charc(4)