연습문제 1번

테이블 (4)

Untitled

  • ssn (Field) — 기본 키
  • projectID (Field2)

department

  • dep10 (Field)
  • name (Field2)
  • mapS (Field3)

employee

  • ssn (Field)
  • name (Field2)
  • address (Field3)
  • phone (Field4)
  • dep10 (Field5)
  • ssn (Field6) — 외래 키 → Untitled.ssn

project

  • projectID (Field)
  • projectNAME (Field2)
  • discription (Field3)
  • duration (Field4)
  • dep10 (Field5)
  • ssn (Field6) — 외래 키 → Untitled.ssn