과제1-1

테이블 (8)

Untitled (DEPARTMENT)

  • Key (deptNo) — char(5) — 기본 키 — NOT NULL
  • Field (name) — char(3)
  • Field (manager) — char(3)
  • Field (managerStartDate) — char(6)
  • Key (employeeNumber) — char(8) — 외래 키 → Untitled.Key — NOT NULL

Untitled (EMPLOYEE)

  • Key (employeeNumber) — char(8) — 기본 키 — NOT NULL
  • Field (name) — char(3)
  • Field (gender) — integer(1)
  • Field (address) — char(12)
  • Field (salary) — integer(11)
  • Field (birthDate) — integer(8)
  • Field (department) — char(3)
  • Field (supervisor) — char(3)
  • Key (deptNo) — char(5) — 외래 키 → Untitled.Key — NOT NULL

Untitled (DEPT-LOCATION)

  • Key (deptNo) — char(5) — 외래 키 → Untitled.Key — NOT NULL
  • Key (PlaceNumber) — integer(11) — 외래 키 → Untitled.Key — NOT NULL

Untitled (LOCATION)

  • Key (PlaceNumber) — integer(11) — 기본 키 — NOT NULL
  • Field (PlaceName) — char(8)
  • Field2 (address) — char(16)

Untitled (DEPENDENT)

  • Key (Dependency number) — char(8) — 기본 키 — NOT NULL
  • Field (name) — char(3)
  • Field2 (gender) — integer(1)
  • Field3 (birthDate) — char(6)
  • Field4 (Relationship) — char(8)
  • Key (employeeNumber) — char(8) — 외래 키 → Untitled.Key — NOT NULL

Untitled (A PROJECT EMPLOYEE)

  • Field (Position) — char(9)
  • Field2 (Participation Rate) — integer(3)
  • Field3 (Salary) — integer(8)
  • Key (employeeNumber) — char(8) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ProjectNo) — char(7) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROJECT)

  • Key (ProjectNo) — char(7) — 기본 키 — NOT NULL
  • Field (name) — char(8)
  • Field2 (Department) — char(3)
  • Field3 (Period) — char(8)
  • Field4 (Price) — integer(8)
  • Key (deptNo) — char(5) — 외래 키 → Untitled.Key — NOT NULL

Untitled (WORKSON)

  • Key (employeeNumber) — char(8) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ProjectNo) — char(7) — 외래 키 → Untitled.Key — NOT NULL
  • Field (ProjectID) — char(8)
  • Field2 (hours) — float
  • Field3 (Field) — charc(4)