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