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.
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.