과제
테이블 (6)
DEPARTMENT (Untitled)
- deptNo (Key) — char(2) — 기본 키 — NOT NULL
- name (Field) — char(20)
- manager (Key2) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- managerStartDate (Field4) — char(8)
- locations (Key3) — 외래 키 → LOCATION.locaNo — NOT NULL
DEPENDENT (Untitled5)
- dependentName (Field)
- gender (Field2)
- birthDate (Field3)
- parent (Field5)
- ssn (Key2) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- relationship (Field4)
EMPLOYEE (Untitled4)
- ssn (Key) — 기본 키 — NOT NULL
- name (Field)
- gender (Field2)
- address (Field3)
- salary (Field4)
- birthDate (Field5)
- department (Key4) — char(2) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
- supervisor (Key3) — 외래 키 → EMPLOYEE.ssn — NOT NULL
LOCATION (Untitled6)
- locaNo (Key) — 기본 키 — NOT NULL
- name (Field2)
- address (Field)
- deptNo (Key2) — char(2) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
PROJECT (Untitled2)
- projNo (Key) — char(2) — 기본 키 — NOT NULL
- name (Field) — char(20)
- controllongDepartment (Key2) — char(2) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
WORKS-ON (Untitled3)
- ssn (Key) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- projNo (Key2) — char(2) — 외래 키 → PROJECT.projNo — NOT NULL
- hours (Field3)