ERD Exercise 0(여영규)

테이블 (7)

DEPARTMENT (Untitled3)

  • departmentId (Key) — char(4) — 기본 키 — NOT NULL
  • departmentName (Field) — char(30)
  • departmentManager (Field2) — char(30)
  • managerStartDate (Field3) — date
  • employeeid (Key2) — char(5) — 외래 키 → EMPLOYEE.employeeid — NOT NULL

DEPART_LOC (Untitled6)

  • depNO (Key) — integer — 기본 키 — NOT NULL
  • departmentId (Key2) — char(4) — 외래 키 → DEPARTMENT.departmentId — NOT NULL
  • locNo (Key3) — integer — 외래 키 → LOCATION.locNo — NOT NULL
  • LocNo (Field) — integer

DEPENDENT (Untitled2)

  • dependentid (Key) — char(10) — 기본 키 — NOT NULL
  • dependentName (Field) — char(10)
  • gender (Field2) — char(5)
  • birthdate (Field3) — date
  • relation (Field4) — char(10)
  • employeeid (Key2) — char(5) — 외래 키 → EMPLOYEE.employeeid — NOT NULL

EMPLOYEE (Untitled)

  • employeeid (Key) — char(5) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • birthdate (Field2) — date
  • address (Field3) — char(30)
  • salary (Field4) — char(10)
  • gender (Field5) — char(5)
  • departmentId (Key2) — char(4) — 외래 키 → DEPARTMENT.departmentId — NOT NULL

LOCATION (Untitled7)

  • locNo (Key) — integer — 기본 키 — NOT NULL
  • locName (Field) — char(100)
  • phone (Field2) — char(15)
  • address (Field3) — char(100)

PROJECT (Untitled4)

  • projectIde (Key) — char(10) — 기본 키 — NOT NULL
  • projectName (Field) — char(30)
  • description (Field2) — text
  • departmentId (Key2) — char(4) — 외래 키 → DEPARTMENT.departmentId — NOT NULL

WORKSON (Untitled5)

  • worksonId (Key) — char(10) — 기본 키 — NOT NULL
  • projectIde (Key2) — char(10) — 외래 키 → PROJECT.projectIde — NOT NULL
  • employeeid (Key3) — char(5) — 외래 키 → EMPLOYEE.employeeid — NOT NULL