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