A foreign key is a function, not a fact!
A foreign key is the result of relationship and identity.
If the relationship changes, so does the foreign key.
The "child" entity gets foreign key attributes to match the identifier of its "parent" entity.
If the parent identifier changes, so does the child's foreign key.
Copyright © 1996 Applied Information Science International