Types of Functional Dependencies

A college keeps every enrolment in one table. Carol White appears in it twice, once for each course she takes.

She changes her name. Now two rows must change together, and if only one of them does, the table disagrees with itself.

The reason is a particular shape of dependency in that table. This lesson gives each shape a name, because the next chapter's rules are written in those names.

The table we will use

Here is Enrollment. Dept is the department the instructor belongs to.