Dependency Diagrams
In this lesson, we will look at the diagrammatic representation of functional dependencies.
We'll cover the following...
Dependency diagrams
A dependency diagram illustrates the various dependencies that might exist in a non-normalized table. A non-normalized table is one that has data redundancy in it. This is illustrated below:
As we can observe from the table above, Project_No
and Emp_No
, combined, are the primary key (as the combination of these two attributes can be used to identify each record uniquely).
The following dependencies can be identified from ...