정보학의 이해 과제(모델링예제 slide20,21)

테이블 (7)

DEPARTMENT

  • Key (departmentID) — char(10) — 기본 키 — NOT NULL
  • Field (department name) — char(20)
  • Field (phone) — char(20)
  • Field (email) — email
  • Field (manager) — char(10)
  • Field (startManageDate) — date
  • Field (location) — char(30)
  • Field (number) — char(10)
  • Key (managerSsn) — char(12) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROJECT)

  • Key (projectID) — char(20) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (description) — longtext
  • Field (project number) — char(30)

Untitled (EMPLOYEE)

  • Key (ssn) — char(12) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(50)
  • Field (email) — email
  • Field (phone) — char(12)
  • Field (gender) — char(1)
  • Field (birthDate) — date
  • Field (wage) — chat(30)
  • Key (departmentID) — char(10) — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Key (departmentID2) — char(10) — 외래 키 → DEPARTMENT.Key — NOT NULL

Untitled (DEPENDENT)

  • Key (dependentID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (gender) — char(1)
  • Field (birthDate) — date
  • Field (relation) — char(10)
  • Key (employeeSsn) — char(12) — 외래 키 → Untitled.Key — NOT NULL

Untitled (WORKSON)

  • Key (ssn) — char(12) — 외래 키 → Untitled.Key — NOT NULL
  • Key (projectID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (hour) — float
  • Key (departmentID) — char(10) — 외래 키 → DEPARTMENT.Key — NOT NULL

Untitled (LOCATION)

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

Untitled (DEPARTMENT_LOCATION)

  • Key (departmentID) — char(10) — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Key (locationID) — char(3) — 외래 키 → Untitled.Key — NOT NULL