모델링예제(슬라이드20,21)

테이블 (7)

DEPENTDNET

  • Key (dependentID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — cahe(30)
  • Field (gender) — cahr(1)
  • Field (birthDate) — date
  • Field (relation) — char(10)
  • (employeeSsn) — char(13) — 외래 키 → EMPLOYEE.ssn — NOT NULL

EMPLOYEE

  • (ssn) — char(13) — 기본 키 — NOT NULL
  • (name) — char(30)
  • (address) — char(30)
  • (email) — email
  • (phone) — char(12)
  • (departmentID) — char(10) — 외래 키 → WORKSFOR.departmentID — NOT NULL
  • Key (dependentID) — char(10) — 외래 키 → DEPENTDNET.Key — NOT NULL

LOCATION

  • Key (locationID) — char(10) — 기본 키 — NOT NULL
  • Field (locationName) — char(20)
  • Field (description) — longtext

PROJECT

  • (projectID) — char(20) — 기본 키 — NOT NULL
  • (name) — char(30)
  • (description) — longtext
  • (departmentID) — char(10) — 외래 키 → WORKSFOR.departmentID — NOT NULL

Untitled (DEPARTMENT_LOCATION)

  • (departmentID) — char(10) — 외래 키 → WORKSFOR.departmentID — NOT NULL
  • Key (locationID) — char(10) — 외래 키 → LOCATION.Key — NOT NULL
  • Field (name) — char(30)

WORKSFOR (DEPARTMENT)

  • (departmentID) — char(10) — 기본 키 — NOT NULL
  • (name) — char(20)
  • (phone) — char(20)
  • (Field3) — email
  • (Field4) — char(10)
  • (startMangeDate) — date
  • (location) — char(30)
  • (ssn) — char(13) — 외래 키 → EMPLOYEE.ssn — NOT NULL

Works on (WORKSON)

  • (ssn) — char(13) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • (projectID) — char(20) — 외래 키 → PROJECT.projectID — NOT NULL
  • Field (hour) — float