슬라이드 20, 21

테이블 (7)

DEPARTMENT

  • Field (deptNo) — char(10) — 기본 키 — NOT NULL
  • Field (emplyeeID) — char(10) — 외래 키 → EMPLOYEE.Key — NOT NULL
  • Key (locationNumber) — char(5) — 외래 키 → DEPARTMENT-LOCATION.Key — NOT NULL
  • Key (name) — char(5)

DEPARTMENT-LOCATION

  • Key (locationNumber) — char(5) — 외래 키 → LOCATION.Key — NOT NULL

EMPLOYEE

  • Key (emplyeeID) — char(15) — 기본 키 — NOT NULL
  • Field (number) — char(10) — 외래 키 → DEPARTMENT.Field — NOT NULL
  • Key (locationNumber) — char(5) — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Field (name) — char(20)
  • Field (gender) — char(1)
  • Field (adress) — text
  • Field (pay) — char(20)
  • Field (ssn) — char(12)
  • Field (birthDate) — char(20)

FAMILY

  • Key (familyNumber) — char(10) — 기본 키 — NOT NULL
  • Field (emplyeeID) — char(15) — 외래 키 → EMPLOYEE.Key — NOT NULL
  • Field (number) — char(10) — 외래 키 → EMPLOYEE.Field — NOT NULL
  • Key (locationNumber) — char(5) — 외래 키 → EMPLOYEE.Key — NOT NULL
  • Field (name) — char(20)
  • Field (gender) — char(1)
  • Field (birthDate) — char(6)

LOCATION

  • Key (locationNumber) — char(5) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (adress) — text

PROJECT (Untitled2)

  • Field (projNo) — char(5) — 기본 키 — NOT NULL
  • Field (emplyeeID) — char(15) — 외래 키 → PROJECT-EMPLOYEE.Field — NOT NULL
  • Key (locationNumber) — char(5) — 외래 키 → PROJECT-EMPLOYEE.Key — NOT NULL
  • Key (name) — char(20)
  • Field (department) — char(20)

PROJECT-EMPLOYEE (Untitled)

  • Field (emplyeeID) — char(15) — 외래 키 → EMPLOYEE.Key — NOT NULL
  • Field (projNo) — char(10) — 외래 키 → EMPLOYEE.Field — NOT NULL
  • Key (locationNumber) — char(5) — 외래 키 → EMPLOYEE.Key — NOT NULL