개체관계모델실습

테이블 (4)

DEPARTMENT

  • depID — char(5) — 기본 키 — NOT NULL
  • name — char(30)
  • ssn (managerssn) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL

EMPLOYEE

  • ssn — char(14) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • address (adress) — char(50)
  • phone — char(11)
  • depID — char(5) — 외래 키 → DEPARTMENT.depID — NOT NULL

PROJECT

  • projectID — char(10) — 기본 키 — NOT NULL
  • projectName — char(30)
  • description — text
  • duration — char(30)
  • depID — char(5) — 외래 키 → DEPARTMENT.depID — NOT NULL

Untitled (WORKSON)

  • ssn — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • projectID — char(10) — 외래 키 → PROJECT.projectID — NOT NULL