How do foreign keys affect partial and transitive dependencies (databases)
If you quote &amp; use definitions for FD (functional dependency), partial FD &amp; transitive FD &amp; for when they hold in a table (value or variable), you will see that they have nothing to do with FKs (foreign keys) or any other table(s).

Also you will see that they have nothing to do with an everyday notion of "derived from". A set of columns is "(functionally) dependent on" another  set or single column when/iff certain conditions are true, as given in the definitions.

Also you will see that the FDs that hold in a table variable are determined by all the values that can arise for it. That is determined by the condition for rows going in the variable in a business situation &amp; all the possible business situations that can arise. But it has nothing to do with whether (a part of) a variable's value "can change after" it holds some different value.

Also if you quote &amp; use definitions for 2NF &amp; 3NF you will see that it is only certain partial and transitive FDs that matter to those NFs.