we did not include the unique constraint and do not foreign key to the accounts table on CustomerID, AccountID from the orders table. (all tables changed to reflect the previously posted queries). we did however leave the AccountID and just added the CustomerID column to the orders table with a foreign key back to the customers table. and while this could lead to an update error our business rules are written that the update is never made.