슬라이드20,21

테이블 (7)

DEPARTMENT

  • Field (number) — char(10) — 기본 키
  • Field (ID) — char(13) — 외래 키 → Untitled.Field
  • Key (locationnumber) — char(5) — 외래 키 → DEPARTMENT-LOCATION.Key — NOT NULL
  • Field (number2) — char(10) — 외래 키 → Untitled.Field
  • Field (ID2) — char(13) — 외래 키 → Untitled.Field
  • Key (locationnumber2) — char(5) — 외래 키 → Untitled.Key — NOT NULL
  • Key (name) — char(5) — NOT NULL

DEPARTMENT-LOCATION (Untitled)

  • Key (locationnumber) — char(5) — 외래 키 → Untitled.Key — NOT NULL

FAMILY

  • Key (familynumber) — char(10) — 기본 키 — NOT NULL
  • Field (ID) — char(13) — 외래 키 → Untitled.Field
  • Field (number2) — char(10) — 외래 키 → Untitled.Field
  • Field (ID2) — char(13) — 외래 키 → Untitled.Field
  • Key (locationnumber) — char(5) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(10)
  • Field (gender) — char(1)
  • Field (birth) — char(6)

Untitled (EMPLOYEE)

  • Field (ID) — char(13) — 기본 키
  • Field (number) — char(10) — 외래 키 → DEPARTMENT.Field
  • Field (ID2) — char(13) — 외래 키 → DEPARTMENT.Field
  • Key (locationnumber) — char(5) — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Key (name) — char(10) — NOT NULL
  • Field (birth) — char(6)
  • Field (adress) — text
  • Field (pay) — char(20)
  • Field (gender) — char(1)
  • Field (ssn) — char(13)

Untitled (PROJECT)

  • Field (number) — char(5) — 기본 키
  • Field (number2) — char(10) — 외래 키 → DEPARTMENT.Field
  • Field (ID) — char(13) — 외래 키 → DEPARTMENT.Field
  • Field (ID2) — char(13) — 외래 키 → Untitled.Field
  • Key (locationnumber) — char(5) — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Field (number22) — char(10) — 외래 키 → DEPARTMENT.Field
  • Field (ID22) — char(13) — 외래 키 → DEPARTMENT.Field
  • Key (locationnumber2) — char(5) — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Key (name) — char(5) — NOT NULL
  • Field (department) — char(20)
  • Field (duration) — char(30)
  • Field (money) — char(30)

Untitled (LOCATION)

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

Untitled (PROJECT-EMPLOYEE)

  • Field (ID) — char(13) — 외래 키 → Untitled.Field
  • Field (number) — char(10) — 외래 키 → Untitled.Field
  • Field (ID2) — char(13) — 외래 키 → Untitled.Field
  • Key (locationnumber) — char(5) — 외래 키 → Untitled.Key — NOT NULL