database_basic
Tables (6)
DEPARTMENT (부서)
- DNumber (부서 고유 번호) — Primary key — NOT NULL
- SSN(Mgr_SSN) (주민번호) — Foreign key → EMPLOYEE.SSN — NOT NULL
DEPENDENT (가족)
- Essn (주민번호) — Primary key — NOT NULL
- dependent_name (가족이름) — Primary key — NOT NULL
- SSN (주민번호2) — Foreign key → EMPLOYEE.SSN — NOT NULL
DEPT_LOCATIONS (부서위치)
- DLocation (부서가 위치한 장소) — Primary key — NOT NULL
- DNumber (부서 분류번호) — Primary key — NOT NULL
- DNumber (부서 고유 번호) — Foreign key → DEPARTMENT.DNumber — NOT NULL
EMPLOYEE (직원)
- SSN (주민번호) — Primary key — NOT NULL
- DNumber (부서 고유 번호) — Foreign key → DEPARTMENT.DNumber — NOT NULL
- Super_SSN (상사의 주민번호) — Foreign key → EMPLOYEE.SSN — NOT NULL
PROJECT (프로젝트)
- Pnumber (프로젝트를 구분하는 고유번호) — Primary key — NOT NULL
- DNumber (부서 고유 번호) — Foreign key → DEPARTMENT.DNumber — NOT NULL
WORKS_ON (진행중인 프로젝트)
- Pnumber (프로젝트를 구분하는 고유번호) — Foreign key → PROJECT.Pnumber — NOT NULL
- SSN (주민번호) — Foreign key → EMPLOYEE.SSN — NOT NULL