예제 ERD

테이블 (5)

DEPARTMENT

  • deptNo — int(10) — 기본 키 — NOT NULL
  • manager (name) — char(30)
  • managerStartDate (manager) — char(30)
  • Field (managerStartDate) — date
  • ssn — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • Key (proNo) — int(20) — 외래 키 → Untitled.Key — NOT NULL

EMPLOYEE

  • ssn — 기본 키 — NOT NULL
  • name — char(30)
  • gender
  • address
  • salary
  • birthDate
  • Field6 (department)
  • Field (supervisor)
  • Field (worksOn)
  • deptNo — int(10) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
  • Key (SSN) — 외래 키 → Untitled.Key — NOT NULL
  • Key (dependentName) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • ssn (ssn2) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • ssn (ssn3) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • ssn (ssn4) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • ssn (ssn5) — 외래 키 → EMPLOYEE.ssn — NOT NULL

Untitled (PROJECT)

  • Key (proNo) — int(20) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (location)
  • Field (controllingDepartment)
  • deptNo — int(10) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
  • Key (SSN) — 외래 키 → Untitled.Key — NOT NULL

Untitled (WORKSON)

  • Key (SSN) — 기본 키 — NOT NULL
  • Field (proNo) — int(20)
  • Field2 (hours) — float
  • ssn — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • Key (proNo2) — int(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (DEPENDENT)

  • Key (dependentName) — char(20) — 기본 키 — NOT NULL
  • Field (gender)
  • Field (birthDate) — date
  • Field (relationship)
  • Field (parent)
  • Field (ssn)
  • ssn (ssn2) — 외래 키 → EMPLOYEE.ssn — NOT NULL