시스템분석론 예재

테이블 (4)

DEPARTMENT (Untitled)

  • departmentID (Key) — character(10) — 기본 키 — NOT NULL
  • departmentName (Field) — character(20)
  • departmentManager (Field2) — int(10)
  • manageStartDate (Field3) — date

EMPLOYEE (Untitled2)

  • employeeID (Key) — int(13) — 기본 키 — NOT NULL
  • employeeName (Field) — character(20)
  • employeeAdress (Field2) — character(30)
  • employeeSex (Field3) — character(1)
  • employeeBirthday (Field4) — int(8)
  • employeeDepartment (Field5) — character(10)
  • employeeSuperviser (Field8) — character(20)
  • employeeProject (Field6) — character(30)
  • employeeWorkTime (Field7) — int(3)

FAMILY (Untitled4)

  • employeeName (Key) — character(20) — 기본 키 — NOT NULL
  • familyName (Field) — character(20)
  • familySex (Field2) — character(1)
  • familyBirthday (Field3) — int(8)
  • familyRelationship (Field4) — character(10)

PROJECT (Untitled3)

  • projectNo (Key) — int(20) — 기본 키 — NOT NULL
  • projectName (Field) — character(30)
  • projectLocation (Field2) — character(30)
  • projectControllingDepartment (Field3) — character(20)