슬라이드 20, 21 예제

테이블 (7)

DEPARTMENT (EMPLOYEE)

  • departmentID (ssn) — char(12) — 기본 키 — NOT NULL
  • name — char(30)
  • gender (address) — char(50)
  • birthdate (email) — email
  • relationship (phone) — char(12)
  • Field (birthDate) — date
  • Field (department) — char(10)
  • Field (gender)
  • Key (departmentID) — char(10) — 외래 키 → EMPLOYEE.Key — NOT NULL

EMPLOYEE (DEPARTMENT)

  • Key (departmentID) — char(10) — 기본 키 — NOT NULL
  • name — char(20)
  • gender (phone) — char(20)
  • address (email) — email
  • salary (manager) — char(10)
  • Field (startMangeDate) — date
  • departmentID (managerSsn) — char(12) — 외래 키 → DEPARTMENT.departmentID — NOT NULL

PROJECT

  • Key (projectID) — char(20) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field2 (description) — longtext
  • Field (location) — char(20)
  • Field (controllingDepartment) — char(10)

Untitled (DEPENDENT)

  • Key2 (dependentID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (gender) — char(1)
  • Field (birthDate) — date
  • Field (relation) — char(10)
  • departmentID (ssn) — char(12) — 외래 키 → DEPARTMENT.departmentID — NOT NULL

Untitled (WORKSON)

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

Untitled (LOCATION)

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

Untitled (DEPARTMENT_LOCATION)

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