Available under Creative Commons-ShareAlike 4.0 International License.
Figure 11.4
A dependency diagram illustrates the various dependencies that may exist in a non normalized table. The following dependencies are identified:
ProjectNo, and EmpNo combined is the PK.
Partial Dependencies:
ProjectNo —> ProjName
EmpNo —> EmpName, DeptNo, HrsWork
Transitive Dependency:
DeptNo —> DeptName
- 1673 reads
