데이터베이스 과제1

테이블 (4)

DEPARTMENT (Untitled)

  • departmentId (Key) — char(4) — 기본 키 — NOT NULL
  • deptName (Field) — char(20)
  • departManager (Field2) — char(30)
  • managerStarDate (Field3) — date

EMPLOYEE (Untitled2)

  • employeeId (Field) — char(5)
  • name (Field2) — char(20)
  • gender (Field3) — char(5)
  • address (Field4) — char(30)
  • birthdate (Field5) — date
  • phone (Field6) — char(11)
  • salary (Field7) — char(11)
  • depatmentId (Key) — char(4) — 외래 키 → DEPARTMENT.departmentId — NOT NULL

PROJECT (Untitled3)

  • projectNo (Field) — char(10)
  • projectName (Field2) — char(30)
  • location (Field3) — char(20)
  • dontrollingDept (Field4) — char(10)
  • departmentId (Key) — char(4) — 외래 키 → DEPARTMENT.departmentId — NOT NULL

WORKSON (Untitled4)