Putting set theory firmly to the side, there is a way to eliminate transitive dependencies. Make sure every relation refers to a single entity.
Here again, is the relation we have been examining in the last few lessons:
Item (ItemNo, Title, Price, CategoryID, CategoryName, CategoryManager)
It refers to two business objects: Items and Categories. The transitive dependency
in the relation, which is in 2NF, causes the relation to have the same problems as a relation that is only in 1NF.
Remember that the relations must be linked by a common field and in this case it is CategoryID.
The next lesson summarizes the process for achieving third normal form and asks you to determine whether relations are in 3NF and to translate relations from 2NF into 3NF.