5주차 과제

테이블 (7)

Employee (Untitled)

  • employeeNo (Key) — 기본 키 — NOT NULL
  • Field5
  • name (Field)
  • email (Field2)
  • address (Field3)
  • phone (Field4)
  • depNo (Key2) — 외래 키 → department.depNo — NOT NULL
  • suvisorNo (Key3) — 외래 키 → Employee.employeeNo — NOT NULL

Location (Untitled3)

  • locNO (Key) — 기본 키 — NOT NULL
  • phone (Field)
  • adress (Field2)

Project (Untitled5)

  • proNo (Key) — 기본 키 — NOT NULL
  • proName (Field)
  • description (Field2)
  • depNo (Key2) — 외래 키 → department.depNo — NOT NULL

Works_On (Untitled6)

  • employeeNo (Key) — 외래 키 → Employee.employeeNo — NOT NULL
  • proNo (Key2) — 외래 키 → Project.proNo — NOT NULL
  • hours (Field)
  • Field2

department (Untitled2)

  • depNo (Key) — 기본 키 — NOT NULL
  • depname (Field)
  • phone (Field2)
  • fax (Field3)
  • employeeNo (Key2) — 외래 키 → Employee.employeeNo — NOT NULL

department_Loc (Untitled4)

  • depNo (Key2) — 외래 키 → department.depNo — NOT NULL
  • locNO (Key3) — 외래 키 → Location.locNO — NOT NULL

dependent (Untitled7)

  • deNo (Key) — 기본 키 — NOT NULL
  • deName (Field)
  • age (Field2)
  • employeeNo (Key2) — 외래 키 → Employee.employeeNo — NOT NULL