When connecting to SQL Server, tables relationships are allowed on only one key. If the field is repeated, it will not consider it as unique though it is since there is more than one key in each tab...
I agree composite keys are a must have for real production scenarios.
