과제

테이블 (8)

Copy Of Untitled (CopyOfemploytee)

  • Key (empSSN) — char(14) — 기본 키 — NOT NULL
  • Field (empName) — char(30)
  • Field (department) — int
  • Key (proName) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (DEPARTMENT)

  • Key (depID) — int — 기본 키 — NOT NULL
  • Field (depName) — char(20)
  • Field (depLocation) — char(20)
  • Field (manager) — int
  • Field (managerStartDate) — date
  • Key (empSSN) — char(14) — 외래 키 → Untitled2.Key — NOT NULL

Untitled (employee)

  • Key (empSSN) — char(14) — 기본 키 — NOT NULL
  • Field (empName) — char(30)
  • Field (department) — int
  • Key (dependentName) — char(20) — 외래 키 → Untitled2.Key — NOT NULL

Untitled (project)

  • Key (proName) — char(20) — 기본 키 — NOT NULL
  • Field (proLocation) — char(20)
  • Field (conrtrollingDepartment) — int
  • Key (empSSN) — char(14) — 외래 키 → Copy Of Untitled.Key — NOT NULL

Untitled2 (EMPLOYEE)

  • Key (empSSN) — char(14) — 기본 키 — NOT NULL
  • Field (empName) — char(30)
  • Field (department) — int
  • Key (depID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled2 (DEPENDENT)

  • Key (dependentName) — char(20) — 기본 키 — NOT NULL
  • Field (gender) — int
  • Field (birthDate) — date
  • Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL

Untitled3 (department)

  • Key (depID) — int — 기본 키 — NOT NULL
  • Field (depName) — char(20)
  • Field (depLocation) — char(20)
  • Field (manager) — int
  • Field (managerStartDate) — date
  • Key (proName) — char(20) — 외래 키 → Untitled4.Key — NOT NULL

Untitled4 (PROJECT)

  • Key (proName) — char(20) — 기본 키 — NOT NULL
  • Field (proLocation) — char(20)
  • Field (controllingDepartment) — int
  • Key (depID) — int — 외래 키 → Untitled3.Key — NOT NULL