Another Database Design Mistake to Avoid is the Redundant Foreign Key.
I’ve seen a redundant FK directly to the parent, of the parent.
In this example, it is the FK relationship from table Three to One.
Result:
Slightly more overhead. Twice as many lookups when inserting into the third table. More difficult maintenance. Less intuitive data model.
Correct by removing the second foreign key.