과제

테이블 (7)

Untitled (EMPLOYEE)

  • Key — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field2 (gender) — char(10)
  • Field3 (address) — char(10)
  • Field4 (phone) — char(10)
  • Field5 (salary) — INT(10)
  • Field6 (depID) — char(4)
  • Key (Key22) — char(10) — 외래 키 — NOT NULL
  • Field (depID2) — char(10) — 외래 키 → Untitled.Field

Untitled (DEPARTMENT)

  • Field (depID) — char(10) — 기본 키
  • Field2 (NAME) — char(10)
  • Field3 (managerID) — char(10)
  • Field4 (managerStartDate) — date
  • Field5 (empID) — char(10)
  • Key (Key3) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field

Untitled (LOCATION)

  • Key — 기본 키 — NOT NULL
  • Field2 (locName) — char(10)
  • Field3 (phone) — char(10)
  • Field4 (email) — email

Untitled (PROJECT)

  • Key (proID) — char(10) — 기본 키 — NOT NULL
  • Field2 (proName) — char(30)
  • Field3 (startDate) — date
  • Field4 (endDate) — date
  • Field5 (description) — text
  • Field6 (managerDepID) — char(10)
  • Field (depID) — char(10) — 외래 키 → Untitled.Field

Untitled (WORKON)

  • Key — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (PROid) — char(10)
  • Field (hourPerWeek) — char(10)
  • Field2
  • Key (proID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (depID2) — char(10) — 외래 키 → Untitled.Field

Untitled (DEPENDANT)

  • Key — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (birthDate) — date
  • Field (relation) — char(10)
  • Field
  • Key (Key2) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (depID2) — char(10) — 외래 키 → Untitled.Field

Untitled2 (DEPARTMENT_LOCATION)

  • Field (depID) — char(10)
  • Field (locID) — char(10)
  • Field (depID2) — char(10) — 외래 키 → Untitled.Field
  • Key — 외래 키 → Untitled.Key — NOT NULL