2023사서교육원_준사서C반_김종우_예제과제

테이블 (5)

Department (Untitled)

  • Key (depNo) — 기본 키 — NOT NULL
  • Field (depName)
  • Field (depLocation)
  • Field (depManager)
  • Field (managerStartDate)
  • Key (ManageEmpssn) — 외래 키 → Employee.Key — NOT NULL

Dependent (Untitled4)

  • Field (dependentName)
  • Field (dependentBirthDate)
  • Field (relationship)
  • Key (CaringEmpssn) — 외래 키 → Employee.Key — NOT NULL
  • Field (dependentGender)

Employee (Untitled3)

  • Key (empssn) — 기본 키 — NOT NULL
  • Field (empName)
  • Field (empGender)
  • Field (empAddress)
  • Field (salary)
  • Field (empbirthDate)
  • Field (supervisor)
  • Key (deptNo) — 외래 키 → Department.Key — NOT NULL
  • Key (SuperviserSsn) — 외래 키 → Employee.Key — NOT NULL

Project (Untitled2)

  • Key (proNo) — 기본 키 — NOT NULL
  • Field (proName)
  • Field (proLocation)
  • Field (managingDept)
  • Key (ManageDepNo) — 외래 키 → Department.Key — NOT NULL
  • Key (ManageEmpssn) — 외래 키 → Employee.Key — NOT NULL

worksOn (Untitled5)

  • Field (prohour)
  • Key (proNo) — 외래 키 → Project.Key — NOT NULL
  • Key (empssn) — 외래 키 → Employee.Key — NOT NULL