各个mysql的依赖,部分依赖（数据库）

I need closure on this.

I fabricated a definition that partial dependency is when fields are indirectly dependent on the primary key or partially dependent but are also dependent on other keys that depend on the primary such that if the field which another field depends on id deleted that field will still exist due to its dependence on the primary key. I am not sure if it is correct. I have researched and every definition sounds misleading.Is my definition correct and if not please explain?

解决方案

A functional dependency that holds in a relation is partial when removing one of the determining attributes gives a functional dependency that holds in the relation.

Eg if {A,B} → {C} but also {A} → {C} then {C} is partially functionally dependent on {A,B}.

A functional dependency X → Y is a full functional dependency if

removal of any attribute A from X means that the dependency does not

hold any more; that is, for any attribute A ε X, (X – {A}) does not

functionally determine Y. A functional dependency X → Y is a partial

dependency if some attribute A ε X can be removed from X and the

dependency still holds; that is, for some A ε X, (X – {A}) → Y.

-- FUNDAMENTALS OF Database Systems SIXTH EDITION Ramez Elmasri & Navathe

(The definition of 2NF involves full functional dependency of non-key attributes on keys but any functional dependecy that holds is either full or partial.)