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 ...