What is the purpose of SQL Server MS creating a check constraint after creating a foreign key constraint?  Doesn't the foreign key constraint already check itself?