연습1

테이블 (5)

DEPENDENT (Untitled4)

  • dependentno (Key) — int — 기본 키 — NOT NULL
  • dependentname (Field) — char(50)
  • gender (Field2) — char
  • birthdate (Field3) — char(14)
  • relation (Field4) — char(20)

EMPLOYEE (Untitled3)

  • ssn (Key) — char(14) — 기본 키 — NOT NULL
  • empname (Field2) — char(50)
  • address (Field3) — char(70)
  • salary (Field4) — int
  • birthdate (Field5) — date
  • gender (Field6) — char(1)
  • supervisor (Field7) — char(14)
  • depeo (Field8) — int
  • depeNo (Key2) — int — 외래 키 → 도시.depeNo — NOT NULL

WORKSON (Untitled5)

  • wono (Key) — int — 기본 키 — NOT NULL
  • ssn (Field) — char(14)
  • proNo (Field2) — int
  • proNo (Field3)
  • prono (Key2) — int — 외래 키 → project.prono — NOT NULL
  • ssn (Key3) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL

project (Untitled2)

  • prono (Key) — int — 기본 키 — NOT NULL
  • proname (Field2) — char50
  • description (Field3) — text
  • managedepartment (Field4) — int

도시 (Untitled)

  • depeNo (Key) — int — 기본 키 — NOT NULL
  • depname (Field2) — char(30)
  • managerno (Field3) — int
  • managestartdate (Field4) — date
  • location (Field5) — char(30)
  • ssn (Key2) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL