Noted equality and foreign key constraints are sometimes required as a result of decomposition in the Normal Form Heirarchy definition doc